EXECUTION OF PROCEDURE WITH OUTPUT PARAMETER

CREATE TABLE dbo.testrun_reports
(
RunID INT IDENTITY(1,1) PRIMARY KEY,
RunDate SMALLDATETIME NOT NULL DEFAULT GETDATE(),
db2dbreport VARCHAR(MAX),
incexcreport VARCHAR(MAX)
);
GO
CREATE PROCEDURE dbo.Run_Start
@RunID INT OUTPUT
AS
SET NOCOUNT ON;
INSERT dbo.testrun_reports
(db2dbreport,incexcreport)
values('Started','Started');
SELECT @RunID = SCOPE_IDENTITY();
GO
----Execution of Procedure
DECLARE @x INT
EXEC Run_Start @x OUTPUT
SELECT @x

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server