Declare local table <column_definition> from variable

67 views Asked by At

I need to create Dynamic columns for local table. This is my example code

Declare @ColumnsTable AS varchar(max) =  '"column_a" varchar(100),"column_b" varchar(100), "column_c" varchar(100)'

Declare @Table AS Table (@ColumnsTable)

Select * from @Table

I can't use EXEC

0

There are 0 answers