请教---[sqlServer 存储过程 转换 mysql]
最近手上有个项目要求sqlServer换成mysql,但存储过程我不知道怎么弄,我在网上找了下说只能一个一个的自己改,不知道有没有人有这类的工具什么的,若有,麻烦那大大发我邮箱577001560@qq.com,谢谢!或者那位会转的大哥帮把我下面这个转一下,我好照着改
REATE PROCEDURE PRO_EMERGENCY_COUNT
--定义参数
@startYear varchar(32), --年份
@startMonth varchar(32) --月 份
--定义变量
AS
DECLARE
@tisdcount int, --灾害点总数
@jy int,--降雨
@ksw int,--库水位
@dz int --地震
set @tisdcount = (select count(*) from tisd_quickly where (year(tisd_happen_time) =@startYear or -1=@startYear)
set @jy = (select count(*) from tisd_quickly where factor like '%1%' and (year(tisd_happen_time) =@startYear or -1=@startYear)
set @ksw = (select count(*) from tisd_quickly where factor like '%2%' and (year(tisd_happen_time) =@startYear or -1=@startYear)
set @dz = (select count(*) from tisd_quickly where factor like '%3%' and (year(tisd_happen_time) =@startYear or -1=@startYear)
CREATE TABLE #CountEmgencyTempTable (
tisdcount int, --灾害点总数
jy int,--降雨
ksw int,--库水位
dz int--地震
);
select * from #CountEmgencyTempTable
GO
-------------------------------------------------------------------
谢谢