我想把参数ID放入临时表名字里,但是显示这里有错误,不知道是哪里的问题
DECLARE @tmp_ID int
SELECT * into ('#TEMP' + @ID) FROM T_BUMON_TREE WHERE [email protected]
DECLARE Cur CURSOR FOR SELECT ID FROM ('#TEMP' + @ID)
------解决方案--------------------
用动态的
- SQL code
declare @sql nvarchar(max)=''set @sql=N'SELECT * into [email protected]+' FROM T_BUMON_TREE WHERE [email protected]+'DECLARE Cur CURSOR FOR SELECT ID FROM [email protected]-- 后面也要用动态的。exec(@sql)