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