语法错误

Question

 不是有效的标识符
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+''''

Answer 1

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+''''

Answer 2

Creator='''+@userName+''''多了一个引号.Creator='''+@userName+'''

Answer 3

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

Answer 4

错了。没看到上面的set