sql - 声明本地表从变量

Question

我需要为本地表创建动态列。这是我的示例代码

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

我无法使用EXEC

标签： sqlsql-servertsql