Posted by Erland Sommarskog on 05/17/06 10:35

surya (suryaitha@gmail.com) writes:
> hello sirs
> purpose OUTPUT keyword with examples

You use OUTPUT to specify that a parameter is an output parameter:

CREATE PROCEDURE getordercount @custid int, @cnt OUTPUT AS
SELECT @cnt = COUNT(*) FROM orders WHERE custid = @custid

What is special with T-SQL, is that you need to specify OUTPUT also when you
call the procedure:

EXEC getordercount @custid, @cnt OUTPUT


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Timeout errors
• Prev in forum: Re: Problem with Delete On Linked Server
• Thread view: Re: purpose of OUTPUT keyword in sql server

[Reply to this message]