Breaking News: Grepper is joining You.com. Read the official announcement!

sql exec output to variable multi value

dr4ft answered on August 2, 2022 Popularity 1/10 Helpfulness 1/10

answer sql exec output to variable multi value

sql exec output to variable multi value

Comment

   DECLARE @dbName nvarchar(128) = 'db_test' --db
	  DECLARE @out1 VARCHAR(50) 
	  DECLARE @out2 VARCHAR(50) 
	  DECLARE @SQL nvarchar(max) = N'SELECT TOP 1 @outputFromExec1 = [id] , @outputFromExec2 = [name] FROM ' + quotename(@dbName) + '.[dbo].[tbl_test]'
	  print 'sql >> ' + @SQL
	  exec sp_executesql @SQL, N'@outputFromExec1 VARCHAR(50) out,@outputFromExec2 VARCHAR(50) out', @out1 out,@out2  out
	  select @out1 as out1 , @out2 as out2

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: exec output sql

Link to this answer
Share Copy Link

Contributed on Aug 02 2022

dr4ft

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

sql exec output to variable multi value

Contents

More Related Answers

sql exec output to variable multi value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.