MS-SQL2005与mysql有哪些区别？该如何解决

MS-SQL2005与mysql有哪些区别？
如果要将一个mysql语句，改成sqlserver，需要改什么？

例如

-- 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;

[解决办法]

SQL code

-- Table structure for kcfiles-- ----------------------------if object_id('kcfiles') is not null   drop table kcfiles;gocreate table kcfiles (  id int not null identity(1,1) primary key,  filename varchar(255) null,  filetype varchar(255) null,  fileurl varchar(255) null);go-- ------------------------------ Table structure for kechens-- ----------------------------if object_id('kechens') is not null   drop table kechens;gocreate table kechens (  id int not null identity(1,1) primary key,  kename varchar(255) null,  jianjie varchar(255) null,  gangyao varchar(255) null,  jiaochen int null,  tid varchar(255) null,  rnum int null,  isPass varchar(10) null);go