帮把一个SQL语句赋值到一个变量里

[验证码识别]

DECLARE @sql varchar (5000)

select * from character as tab1 where  @raceids  like   '%|'+rtrim(ltrim(raceid))+'|%' and  @classids  like   '%|'+rtrim(ltrim(classid))+'|%'

set @sql = ？？？

帮把SQL语句赋值到 @sql

[cd731107]

set @sql ='select * from character as tab1 where  '+ltrim(@raceids)+'  like   ''%|''+rtrim(ltrim(raceid))+''|%'' and ' +ltrim(@classids)+'  like   ''%|''+rtrim(ltrim(classid))+''|%'''

[-晴天]

DECLARE @sql varchar (5000)
declare @raceids varchar(100),@classids varchar(100)
set @raceids='abcd'
set @classids='0001'

set @sql='select * from character as tab1 where '''+ @raceids +''' like ''%|''+rtrim(ltrim(raceid))+''|%'' and '''+ @classids +''' like ''%|''+rtrim(ltrim(classid))+''|%'''

select @sql
/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from character as tab1 where 'abcd' like '%|'+rtrim(ltrim(raceid))+'|%' and '0001' like '%|'+rtrim(ltrim(classid))+'|%'

(1 行受影响)

*/

[cd731107]

--变量也应该用两个'括起来
set @sql ='select * from character as tab1 where  '''+ltrim(@raceids)+'''  like   ''%|''+rtrim(ltrim(raceid))+''|%'' and ''' +ltrim(@classids)+'''  like   ''%|''+rtrim(ltrim(classid))+''|%'''

[验证码识别]

[Quote=引用 2 楼 qianjin036a 的回复:]
SQL code

DECLARE @sql varchar (5000)
declare @raceids varchar(100),@classids varchar(100)
set @raceids='abcd'
set @classids='0001'

set @sql='select * from character as tab1 where '''+ @raceid……
[/Quote]
rtrim(ltrim(raceid))

raceid 是字段名字，怎么处理？

[验证码识别]

[Quote=引用 3 楼 cd731107 的回复:]
SQL code

--变量也应该用两个'括起来
set @sql ='select * from character as tab1 where '''+ltrim(@raceids)+''' like ''%|''+rtrim(ltrim(raceid))+''|%'' and ''' +ltrim(@classids)+''' like ''%|''+rtrim(ltri……
[/Quote]
rtrim(ltrim(raceid))

raceid 是字段名字，怎么处理？

[cd731107]

[Quote=引用 5 楼 yzm888 的回复:]
引用 3 楼 cd731107 的回复:
SQL code

--变量也应该用两个'括起来
set @sql ='select * from character as tab1 where '''+ltrim(@raceids)+''' like ''%|''+rtrim(ltrim(raceid))+''|%'' and ''' +ltrim(@classids)+''' like ''……
[/Quote]

set @sql ='select * from character as tab1 where  '''+ltrim(@raceids)+'''  like   ''%|''+rtrim(ltrim('''+raceid+'''))+''|%'' and ''' +ltrim(@classids)+'''  like   ''%|''+rtrim(ltrim('''+classid+'''))+''|%'''

[--小F--]

set @sql =
      'select
          * 
       from
          character as tab1 
       where  
          '''+ltrim(@raceids)+'''  
       like
          ''%|''+rtrim(ltrim('''+raceid+'''))+''|%'' 
       and  
          ''' +ltrim(@classids)+'''  
       like  
          ''%|''+rtrim(ltrim('''+classid+'''))+''|%'''

[AcHerat]

set @sql='select * from character as tab1 where '''
        + @raceids +''' like ''%|''+rtrim(ltrim(raceid))+''|%'' and '''
        + @classids +''' like ''%|''+rtrim(ltrim(classid))+''|%'''

字段名一样啊！又不是变量不用放外边，就放在字符串引号里面表示的就是那个表的字段名！