June 9, 2011

Execute OUTPUT parameter procedure in SQL Server

DECLARE @CountNoSal INT

EXECUTE SalUpdate 12000,@NoSal=@CountNoSal OUTPUT
PRINT @CountNoSal

No comments:

Post a Comment