解决方法
这是一个端到端的例子：
-- Define a custom TABLE type CREATE TYPE IntegerTableType AS TABLE (ID INTEGER); -- Fill a var of that type with some test data DECLARE @MyTable IntegerTableType INSERT @MyTable VALUES (1),(2),(3) -- Now this is how you pass that var into dynamic statement EXECUTE sp_executesql N'SELECT * FROM @MyTable',N'@MyTable IntegerTableType READONLY',@MyTable
