SQL 代码如下:
DECLARE @userID char(10)
SET @userID='u1'
DECLARE @sQry nvarchar(4000)
SET @sQry='SELECT * FROM T_Project WHERE '
+ ' f5=''+cast(RTRIM(LTRIM(@userID)) as nchar(10))+'''请问:@sQry 的值是什么?
DECLARE @userID char(10)
SET @userID='u1'
DECLARE @sQry nvarchar(4000)
SET @sQry='SELECT * FROM T_Project WHERE '
+ ' f5=''+cast(RTRIM(LTRIM(@userID)) as nchar(10))+'''请问:@sQry 的值是什么?
+ ' f5=''+cast(RTRIM(LTRIM(@userID)) as nchar(10))+'''
SET @userID='u1'
DECLARE @sQry nvarchar(4000)
SET @sQry='SELECT * FROM T_Project WHERE '
+ ' f5='''+cast(RTRIM(LTRIM(@userID)) as nchar(10))+'''' --少了'號
Print @sQry --Print出來,你就知道@sQry是什麼了--Result
/*
SELECT * FROM T_Project WHERE f5='u1 '
*/
SELECT * FROM T_Project WHERE f5='+cast(RTRIM(LTRIM(@userID)) as nchar(10))+'
SET @userID='u1'
DECLARE @sQry nvarchar(4000)
SET @sQry='SELECT * FROM T_Project WHERE f5='''+cast(RTRIM(LTRIM(@userID)) as nchar(10))+''''