DECLARE @userName varchar(30)
SET @userName='KaowuTest'
DECLARE @sqlget varchar(1000)
SET @sqlget='
SELECT [RequestListID]
,[RequestListNo]
,[RequestListName]
,[TaskTypeCode]
,[ProjectID]
,[IsFinance]
,[TaskBackground]
,[Taskdescription]
,[IsOpen]
,[CreateDate]
,[Creator]
,[CreatorName]
,[Re]
FROM dbo.Task_OtherRequestList
where Creator='''+@userName+'''
union
SELECT [RequestListID]
,[RequestListNo]
,[RequestListName]
,[TaskTypeCode]
,[ProjectID]
,[IsFinance]
,[TaskBackground]
,[Taskdescription]
,[IsOpen]
,[CreateDate]
,[Creator]
,[CreatorName]
,[Re]
FROM dbo.Task_RequestList where Creator='''+@userName+''''
exec @sqlget出错 不是有效的标识符但是我用print打出sqlget再运行就没错
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货