how to pass out parameters in T-sql procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

how to pass out parameters in T-sql procedure

Author

Topic

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2009-06-25 : 09:22:28

Hi,
i am using a procedure where i want to pass an out parameters in the block that i shoud be able to written it in a query in a T-sql procedure.can anyone help me with an example related to this?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-25 : 09:25:24

use the OUTPUT parameter

add the OUTPUT to the parameter list


create procedure test
   @colin  int,
   @colout int OUTPUT
as
 . . .

KH
[spoiler]Time is always against us[/spoiler]

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2009-06-25 : 09:29:14

thanks khhtan but i want to use that in in the biddle of the procedure so that i sholud be able to use that for returning it through a query.can you send a sample proceure on a whole.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-25 : 09:43:14

http://msdn.microsoft.com/en-us/library/ms378108(SQL.90).aspx

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources