surya (su*******@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,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx