求高手翻一下语句~解决方法

求高手翻一下语句~急急急
把下面的mysql语句改成sqlserver的，急急急


SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for answers
-- ----------------------------
DROP TABLE IF EXISTS `answers`;
CREATE TABLE `answers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `generalsrid` varchar(255) default NULL,
  `tid` varchar(255) default NULL,
  `answer` varchar(255) default NULL,
  `uid` varchar(255) default NULL,
  `savetime` varchar(255) default NULL,
  `total` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for kcfiles
-- ----------------------------
DROP TABLE IF EXISTS `kcfiles`;
CREATE TABLE `kcfiles` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `filetype` varchar(255) default NULL,
  `fileurl` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for kechens
-- ----------------------------
DROP TABLE IF EXISTS `kechens`;
CREATE TABLE `kechens` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `kename` varchar(255) default NULL,
  `jianjie` varchar(255) default NULL,
  `gangyao` varchar(255) default NULL,
  `jiaochen` int(20) default NULL,
  `tid` varchar(255) default NULL,
  `rnum` int(20) default NULL,
  `isPass` varchar(10) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `picurl` varchar(255) default NULL,
  `content` text,
  `savetime` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for notices
-- ----------------------------
DROP TABLE IF EXISTS `notices`;
CREATE TABLE `notices` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ntitle` varchar(255) default NULL,
  `ncontent` varchar(255) default NULL,
  `tid` varchar(255) default NULL,
  `kid` varchar(255) default NULL,
  `stime` varchar(255) default NULL,
  `etime` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for shitis
-- ----------------------------
DROP TABLE IF EXISTS `shitis`;
CREATE TABLE `shitis` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `kechen` varchar(255) default NULL,
  `zhangjie` varchar(255) default NULL,
  `scontent` varchar(255) default NULL,
  `stype` varchar(255) default NULL,
  `answers` varchar(255) default NULL,
  `fenzhi` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for sysuser
-- ----------------------------
DROP TABLE IF EXISTS `sysuser`;
CREATE TABLE `sysuser` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uname` varchar(255) default NULL,
  `upass` varchar(255) default NULL,
  `utype` varchar(255) default NULL,
  `tname` varchar(255) default NULL,
  `sex` varchar(255) default NULL,
  `tel` varchar(255) default NULL,
  `email` varchar(255) default NULL,