最近手上有个项目要求sqlServer换成mysql,但存储过程我不知道怎么弄,我在网上找了下说只能一个一个的自己改,不知道有没有人有这类的工具什么的,若有,麻烦那大大发我邮箱[email protected],谢谢!或者那位会转的大哥帮把我下面这个转一下,我好照着改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-------------------------------------------------------------------
谢谢
--定义参数
@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-------------------------------------------------------------------
谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货