<< SQL Find all procedures that contains a specific text | How to use SPMenuField into SharePoint's SPGridView with postbacks >>

Execute a stored procedure at SQL Server Management Studio with output parameter

Monday, 29 June 2009 17:27 by myro

Here's a reminder for myself when I need to launch a stored procedure with an output parameter directly from SQL Server Management. Who knows... maybe can helps you too.

declare @P1 int

set @P1=NULL

declare @P2 char(1)

set @P2=NULL

exec STORED_PROCEDURE 0, 'foo', 144133917, '0', @P1 output, @P2 output select @P1, @P2

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:		t-sql
Categories:		Sql
Actions:		\| Permalink \| Comments (0) \| Comment RSS

If you consider this post usefull for your purposes, please consider visiting my sponsors to help me out with the myrocode.com maintenance. Thank you.

Find a table by name into SQL Server 2000 and SQLServer 2005 In SQL Server 2005 you can get a list of all your Tables with a particular name using the system t...SQL Find all procedures that contains a specific text Let's says you need to find out all the stored procedures that reference a column or that just...SQL Server - Find all Tables in Database that contains a specific column If you need to query your sql server's database to find out where a specific column is present...

Execute a stored procedure at SQL Server Management Studio with output parameter

Related posts

myrocode.com

Twitter updates

Search

Tags

Categories

Archive

Blogroll