2014/07/14

How to read value returned by stored procedure - TSQL ?

http://msdn.microsoft.com/en-us/library/ms188332.aspx
DECLARE @ret INT
EXEC @ret = [schImports].[uspInsertImport] 1
view raw gistfile1.sql hosted with ❤ by GitHub

CREATE PROCEDURE [schImports].[uspInsertImport] (@importId int)
AS
BEGIN
-- ...
return @insertedNew;
END
view raw gistfile1.sql hosted with ❤ by GitHub

No comments:

Post a Comment