hello sirs
purpose OUTPUT keyword with examples
-
hello sirs
purpose OUTPUT keyword with examples
-
Re: purpose of OUTPUT keyword in sql server
surya (suryaitha@gmai l.com) writes:[color=blue]
> hello sirs
> purpose OUTPUT keyword with examples[/color]
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@sommarsk og.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
-
Re: purpose of OUTPUT keyword in sql server
Erland,
you said right about OUTPUT parameters...
but what about the OUTPUT clause of
DELETE, INSERT and UPDATE statements
in SQL Server 2005?
surya, for more details about the OUTPUT clause see the following link:
---
Andrey Odegov
avodeGOV@yandex .ru
(remove GOV to respond)
Comment
-
Re: purpose of OUTPUT keyword in sql server
avode (avode_spam@yah oo.com) writes:[color=blue]
> you said right about OUTPUT parameters...
> but what about the OUTPUT clause of
> DELETE, INSERT and UPDATE statements
> in SQL Server 2005?[/color]
Sorry! There's so much new stuff, that I tend to forget some of it.
The OUTPUT clause in one of the more obscure items.
[color=blue]
> surya, for more details about the OUTPUT clause see the following link:
> http://msdn2.microsoft.com/en-us/library/ms177564.aspx[/color]
....and if it was in that context you asked about OUTPUT, surya, please
tell us if you want more clarifcation.
Thanks for posting the link Andrey.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Comment
Comment