34,576
社区成员
发帖
与我相关
我的任务
分享请教如下SQL语句？ 我将如何操作阿
update tblsysfielddesc
set datasource = 'select nbbm as myvalue, zqjc as mytext from usrzqzb where gpdm like '''%''' and zqlb like '''%''' and YWMCSX like '''%'''' where tblname = 'usrCPCLB' and fldname='CPFLFS'
以上，在 % 符号周围，我想留有 ' 符号，可是这样又无法更新数据。该怎么做啊
set datasource = 'select nbbm as myvalue, zqjc as mytext from usrzqzb where gpdm like '''%''' and zqlb like '''%''' and YWMCSX like '''%'''' where tblname = 'usrCPCLB' and fldname='CPFLFS'
以上，在 % 符号周围，我想留有 ' 符号，可是这样又无法更新数据。该怎么做啊
...全文
请发表友善的回复…
发表回复
jie115 2004-07-29
- 打赏
- 举报
谢谢 victorycyz(中海)
zheninchangjiang 2004-07-29
- 打赏
- 举报
'select nbbm as myvalue, zqjc as mytext from usrzqzb where gpdm like ''''%'''' and zqlb like ''''''%'''''' and YWMCSX like ''''''%'''''' where tblname = ''usrCPCLB'' and fldname=''CPFLFS''' --这样呢
victorycyz 2004-07-29
- 打赏
- 举报
update tblsysfielddesc
set datasource = 'select nbbm as myvalue, zqjc as mytext from usrzqzb where gpdm like ''%'' and zqlb like ''%'' and YWMCSX like ''%'''
where tblname = 'usrCPCLB' and fldname='CPFLFS'
set datasource = 'select nbbm as myvalue, zqjc as mytext from usrzqzb where gpdm like ''%'' and zqlb like ''%'' and YWMCSX like ''%'''
where tblname = 'usrCPCLB' and fldname='CPFLFS'
