begin
set @s_sql= concat(' select count(distinct b.id) into @tempcount from ',filter);
prepare stmt1 from @s_sql;
execute stmt1;
deallocate prepare stmt1;
set totalNum=@tempcount;
end----------------------------------------
begin
set @s_sql=concat('select * from hell l where l.ed=1 ',filter,' limit ',currPage,' , ', pageSize);
prepare stmt1 from @s_sql;
execute stmt1;
deallocate prepare stmt1;
end----------------------------------------------------------------------上面是两个mysql 的存储过程的写法
想叫大家帮忙把上面的mysql 存储过程改为 server 2005 存储过程写法。
set @s_sql= concat(' select count(distinct b.id) into @tempcount from ',filter);
prepare stmt1 from @s_sql;
execute stmt1;
deallocate prepare stmt1;
set totalNum=@tempcount;
end----------------------------------------
begin
set @s_sql=concat('select * from hell l where l.ed=1 ',filter,' limit ',currPage,' , ', pageSize);
prepare stmt1 from @s_sql;
execute stmt1;
deallocate prepare stmt1;
end----------------------------------------------------------------------上面是两个mysql 的存储过程的写法
想叫大家帮忙把上面的mysql 存储过程改为 server 2005 存储过程写法。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货