首页 > 代码库 > SQL代码-创建DeskInfo表

SQL代码-创建DeskInfo表

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 

 

SQL代码-创建DeskInfo表