SQL数据库期末复习备考必备.docxVIP

数据库的创建：create DATABASE stuManage 表的创建：use stuManage go create table department 数据的插入：use stuManage insert into department(dNO,dName,dTel) values(115500,金融系,02085560371) 数据修改：use stuManage update teacher set tRank =副教授 where tBirth 1979/12/31 数据删除：use stuManage delete department where dName = 金融系 数据