将MySQL中的存储过程改成SQL Server中的

如何将这段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;;

参考：https://www.cnblogs.com/huxiaolin/p/4671039.html
http://bbs.51cto.com/thread-1115779-1.html