create table DeskInfo ( DeskId int primary key not null identity (1,1), DeskName varchar(20) , DeskNamePinYin varchar(20), DeskDelFlag int, DeskNum int ) select DeskId,DeskName,DeskNamePinYin,DeskNum into DeskInfo
原文：http://www.cnblogs.com/blacop/p/6056484.html