如何将这段MySQL中的存储过程改成SQL Server的
DELIMITER ;;
DROP PROCEDURE IF EXISTS creatTableYp_a;;
CREATE DEFINER=root@% PROCEDURE creatTableYp_a(IN table_name char(100))
BEGIN
#Routine body goes here...
#set @temp= "table_name7788";
#DROP TABLE IF EXISTS @temp;
set @table_body= "(key_id int(11) NOT NULL DEFAULT '0' COMMENT '主键',matchid int(11) DEFAULT NULL COMMENT '上 终',home_now int(5) DEFAULT NULL COMMENT '上盘 即时',handicap_now int(5) DEFAULT NULL COMMENT '盘口',guest_now int(5) DEFAULT NULL COMMENT '下盘',com_id int(3) DEFAULT '0' COMMENT '赔率公司ID' ,reduce_now int(11) DEFAULT NULL COMMENT '终盘差值',
KEY seach (matchid,home_now,handicap_now,guest_now,com_id,reduce_now) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='大小亚赔主胜表';";
SET @dbName = table_name;
#DROP TABLE IF EXISTS ",@dbName," ;
SET @STMT2 :=CONCAT("DROP TABLE IF EXISTS ",@dbName,";");
PREPARE STMT2 FROM @STMT2;
EXECUTE STMT2;
SET @STMT :=CONCAT(" CREATE TABLE ",@dbName,@table_body);
PREPARE STMT FROM @STMT;
EXECUTE STMT;
END;;
