SQL server中写存储过程，有没有能实现在用变量作为查询条件的方法呢？

Question

DECLARE @s varChar(100)
DECLARE @SQl varChar(100)select @s='DATEDIFF(DAY,GETDATE(),dtmEndTime) >200'
select @SQl='SELECT  uniUser_ID,
              strCompanyName,
              strEmail,
              intUserType,
              strUserModel,
              intStartStop,
              dtmEndTime,
              dtmDay= DATEDIFF(DAY,GETDATE(),dtmEndTime) 
FROM  UserInformation WHERE ' + @sexec (@Sql)

Answer 1

来慢了,动态sql,如Haiwer(海阔天空)　

Answer 2

有个问题,自己改一下(@SQl定义100恐怕不够):DECLARE @s varChar(100)
DECLARE @SQl varChar(250)select @s='DATEDIFF(DAY,GETDATE(),dtmEndTime) >200'
select @SQl='SELECT  uniUser_ID,
              strCompanyName,
              strEmail,
              intUserType,
              strUserModel,
              intStartStop,
              dtmEndTime,
              dtmDay= DATEDIFF(DAY,GETDATE(),dtmEndTime) 
FROM  UserInformation WHERE ' + @sexec (@Sql)