这是执行存储过程的代码:exec GetDataByLine5,'select B.VC_SEVERITYNAME,A.* from DT_ALARM A join DM_ALARMSEVERITY B on A.INT_SEVERITY = B.INT_SEVERITY Where 0=0 AND A.VC_EMNAME like '%CSHA11%'',0,2
就是 有2个%% 号的那里、 各位 大侠 们救救 小弟
...全文
5636打赏收藏
sybase 执行带参的存储过程 出现两个单引号 怎么解决啊~~ 帮忙。
这是执行存储过程的代码:exec GetDataByLine5,'select B.VC_SEVERITYNAME,A.* from DT_ALARM A join DM_ALARMSEVERITY B on A.INT_SEVERITY = B.INT_SEVERITY Where 0=0 AND A.VC_EMNAME like '%CSHA11%'',0,2 就是 有2个%% 号的那里、 各位 大侠 们救救 小弟
exec GetDataByLine5,'select B.VC_SEVERITYNAME,A.* from DT_ALARM A join DM_ALARMSEVERITY B on A.INT_SEVERITY = B.INT_SEVERITY Where 0=0 AND A.VC_EMNAME like '%CSHA11%'',0,2
a:双引号和单引号岔开使用
"select B.VC_SEVERITYNAME,A.* from DT_ALARM A join DM_ALARMSEVERITY B on A.INT_SEVERITY = B.INT_SEVERITY Where 0=0 AND A.VC_EMNAME like '%CSHA11%' "
b:如果必须得用单引号的话,转移符也是单引号,稍微有点儿绕
'select B.VC_SEVERITYNAME,A.* from DT_ALARM A join DM_ALARMSEVERITY B on A.INT_SEVERITY = B.INT_SEVERITY Where 0=0 AND A.VC_EMNAME like ''%CSHA11%'' '
先用楼上的方法试试。或者外边用双引号,里边用单引号:
"select B.VC_SEVERITYNAME,A.* from DT_ALARM A join DM_ALARMSEVERITY B on A.INT_SEVERITY = B.INT_SEVERITY Where 0=0 AND A.VC_EMNAME like '%CSHA11%'"