Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First SP
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Divers
Thread ID:
00759576
Message ID:
00759724
Vues:
31
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform