>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