触发器中语句出错Syntax error near 'into' on line ...

[isalsfy]

declare cer_no char(10);
declare cer_count integer;
declare cmd char(256);
set cmd = 'select count(*) from calibration where C2395 like ''' || cer_no || '%''';
execute immediate cmd into cer_count;

这段语句问题在哪里，请帮忙看看，在线等……

[Sybase数据库恢复]

看看手册吧。

[ceozenliu]

set cmd = 'select cer_count=count(*) from calibration where C2395 like ''' || cer_no || '%'''; execute immediate cmd ;

[lgjlry]

declare @cer_no char(10); declare @cer_count integer; declare @cmd char(256); set @cmd = 'select count(*) from calibration where C2395 like ''' || cer_no || '%'''; execute immediate @cmd into @cer_count;