Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving a value
Message
From
04/12/2002 08:24:41
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00728752
Message ID:
00729388
Views:
21
If I understand your question...Try this:

1- Put the variable '@Result' like a new parameter with the 'Output' at the end
2- and check the execution at the end

================================================
CREATE PROCEDURE AAA
@COLNUM smallint,
@RESULT varchar(100) output
AS

DECLARE @TESTFIELD varchar(100)

set @TESTFIELD = COL_NAME(OBJECT_ID('Northwind.dbo.Employees'),@COLNUM )

DECLARE Employee_Cursor CURSOR FOR
SELECT @TESTFIELD FROM Northwind.dbo.Employees
OPEN Employee_Cursor
FETCH NEXT FROM Employee_Cursor into @RESULT

CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor

/* When you will excute your SP
declare @x datetime
set @x = null
execute aaa 1, @x output
select @x
*/

Dave
Technologies Nter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform