IF EXISTS(SELECT * FROM sys.Tables WHERE name='stu_info')
  DROP TABLE stu_info
Go
Create table
stu_info
(stu_id    int  identity(1,1),
name       nvarchar(20)not null,
birthday   date null,
sex        nvarchar(2)null,
addres    nvarchar(20)null,
mark       int null,
major      nvarchar(20)null,
sdept     nvarchar(20)null );

Insert Into stu_info(name,birthday,sex,addres,mark,major,sdept)values('张三','1991-01-01','男','山东',1,'数学','神马');
Insert Into stu_info(name,birthday,sex,addres,mark,major,sdept)values('李四','1991-01-01','男','北京',1,'数学','神马');