【文件属性】：
文件名称：Microsoft SQL Server Query File
文件大小：420B
文件格式：SQL
更新时间：2017-06-09 02:43:38
SQL
建立数据库的表
ALTER TABLE student ADD s_birthday DATETIME;
ALTER TABLE student ADD s_home char;
ALTER TABLE student DROP column s_home;
CREATE UNIQUE INDEX sname_index on student(sname);
INSERT
INTO student(sno,sname,ssex,sdept,sage,s_birthday)
VALUES('2003125','aa','男','qs',18,'2001/12/20');
set dateformat mdy
select* from student
ALTER TABLE student ADD ssex char(2);
ALTER TABLE student ADD sage char(4);