文件名称：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);