sybase 执行带参的存储过程 出现两个单引号 怎么解决啊~~ 帮忙。

[pjwtxq]

这是执行存储过程的代码：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个%% 号的那里、 各位 大侠 们救救 小弟

[rucypli]

like ''%CSHA11%''

[iihero]

先用楼上的方法试试。或者外边用双引号，里边用单引号:
"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%'"

[pjwtxq]

都 不行 3楼 的 sql语句能有 “” 么 纠结了

[iihero]

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

都 不行 3楼 的 sql语句能有 “” 么 纠结了
[/Quote]

作为参数，可以，你为什么不试一试

[lileizhang]

改为%%CSHA11%%

[wumugulu]

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%'' '