Search This Blog

Thursday, February 2, 2017

exec SP Data to store a variable in SQL Server

DECLARE @Output1 VARCHAR(100), Output2 VARCHAR(100)

CREATE TABLE #tmpTable
(
    OutputValue1 VARCHAR(100), OutputValue2 VARCHAR(100),
)
INSERT INTO #tmpTable (OutputValue1,OutputValue2)
EXEC dbo.sp_name

SELECT
    @Output = OutputValue1, Output2= OutputValue2
FROM 
    #tmpTable

DROP TABLE #tmpTable
print @Output1

No comments:

Post a Comment