Microsoft SQL Server Query File

建立数据库的表 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);