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