34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @SQL NVARCHAR(4000)
SET @SQL=N'SELECT * FROM tt WHERE 1=1'
DECLARE @WHERE NVARCHAR(4000)
DECLARE @NUM INT
SET @NUM=1
IF(@NUM>0)
SET @WHERE=ISNULL(@WHERE,'')+' AND NUM='+LTRIM(@NUM)
SET @SQL=@SQL+@WHERE
PRINT @SQL
/*SELECT * FROM tt WHERE 1=1 AND NUM=1
declare @tt varchar(100),@sql varchar(200)
set @sql='select * from where tt='+@tt
exec(@sql)