variables as columns in a Table Variable SQL

Question

I want to pass variables as columns in a Table Variable.

DECLARE @VAR1 NVARCHAR(MAX)
DECLARE @VAR2 NVARCHAR(MAX)

and I have set values in these variables. Now I want to form a table from these results.

This is what I have tried

DECLARE @Query TABLE(@Pvar1,@Total)

Desired output:

Var1   Var2

 abc    xyz

Do you want to use the variables to determine the field type or content? — Gidil
– Gidil, Commented Jul 31, 2014 at 6:46

deterministicFail · Accepted Answer · 2014-07-31 06:53:18Z

1

In SQL-Server you cant declare a table variable with other variables, you have to use the same datatype

DECLARE @var1 NVARCHAR(MAX) = 'abc'
DECLARE @var2 NVARCHAR(MAX) = 'xyz'

DECLARE @table TABLE(
   var1 NVARCHAR(MAX),
   var2 NVARCHAR(MAX)
)

INSERT INTO @table SELECT @var1, @var2

SELECT * FROM @table

answered Jul 31, 2014 at 6:53

deterministicFail

1,2819 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

variables as columns in a Table Variable SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related