表作为变量时,应该这样
DECLARE @TableName NVARCHAR (100)
Select @TableName='dbo.TMP_Template'DECLARE HeadTemplate_Cursor cursor for
select LeftStr,MiddleStr,RightStr from '+@TableName+'
DECLARE @TableName NVARCHAR (100)
Select @TableName='dbo.TMP_Template'DECLARE HeadTemplate_Cursor cursor for
select LeftStr,MiddleStr,RightStr from '+@TableName+'
不对,此行语法有错误
''不框成一个字符串了吗?
我觉得可能需要什么语句来代换
Select @TableName='dbo.TMP_Template'exec('DECLARE HeadTemplate_Cursor cursor for'
+' select LeftStr,MiddleStr,RightStr from '+@TableName)
97866(weiLuang) 高人,俺咱没想到捏