SQLServer——用代码创建数据表

340 阅读1分钟

代码:

create table Teacher ( Id int identity(1,1), Name nvarchar not null, Gender bit not null, Age int check(age>0 and age<=100)not null, Salary money, Birthday datetime not null default('2000-9-9') )