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

2011-07-09 05:59:11 175 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SQL语句中使用VB控件的属性或变量 Dim strSQL As String strSQL= "select 口令 from 系统用户 where 用户名=' " & UserName & " ' " 以上两句话的意思即为给字符串变量strSQL赋值，右边的值则是通过select语句实现。在SQL语法中，字符串需要用单引号' '括起来，select语句应为： select 口令 fr 阅读详情



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

...全文

从SRIOV到SIOV：PCIe虚拟化技术下一代革命如果说SR-IOV是过去十年PCIe虚拟化的“标杆方案”，那SIOV就是为超大规模云数据中心、AI集群量身打造的“破局者”——它解决了SR-IOV难以逾越的扩展性瓶颈，同时平衡了性能、成本与生态兼容性。今天就从“为什么需要SIOV”到“SIOV到底强在哪”，再到“未来要解决什么问题”，做一次全方位深度拆解。阅读详情

验证码识别

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

AcHerat 元老 2011-07-09

打赏
举报



set @sql='select * from character as tab1 where '''

        + @raceids +''' like ''%|''+rtrim(ltrim(raceid))+''|%'' and '''

        + @classids +''' like ''%|''+rtrim(ltrim(classid))+''|%'''

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

--小F-- 2011-07-09

打赏
举报

set @sql =

      'select

          * 

       from

          character as tab1 

       where  

          '''+ltrim(@raceids)+'''  

       like

          ''%|''+rtrim(ltrim('''+raceid+'''))+''|%'' 

       and  

          ''' +ltrim(@classids)+'''  

       like  

          ''%|''+rtrim(ltrim('''+classid+'''))+''|%'''

cd731107 2011-07-09

打赏
举报

[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+'''))+''|%'''

验证码识别 2011-07-09

打赏
举报

[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 是字段名字，怎么处理？

验证码识别 2011-07-09

打赏
举报

[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 是字段名字，怎么处理？

cd731107 2011-07-09

打赏
举报

--变量也应该用两个'括起来

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

-晴天 2011-07-09

打赏
举报

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 2011-07-09

打赏
举报

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

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

相关推荐