Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First SP
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Miscellaneous
Thread ID:
00759576
Message ID:
00759724
Views:
29
>Yes.
Thanks a lot. Now how can I test it?
declare @tnCartID int 

EXECUTE USP_Insert_ShoppingCartInfo 
	'11111111111'  ,
        5 ,
        'Test' 	,
        'B' ,
	'Test selection' ,
        '1,2,3' ,
        @tnCartID OUTPUT
I've read Help on EXECUTE, but don't understand about return value.

Disregard: This example executes the checkcontract stored procedure on the remote server SQLSERVER1 and stores the return status indicating success or failure in @retstat.

DECLARE @retstat int
EXECUTE @retstat = SQLSERVER1.pubs.dbo.checkcontract '409-56-4008'
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform