INSERTINTO class (name,teacher_name)VALUES('软件班','张三')INSERTINTO class (name,teacher_name)VALUES('软件2班',NULL)INSERTINTO class VALUES('计算机应用班','李四')INSERTINTO class VALUES('网络班','王五')
INSERTINTO class (name,teacher_name)SELECT'软件1班','张三'UNIONSELECT'软件2班','李四'UNIONSELECT'软件3班','王五'
复制的两种方式
copy1
SELECT*INTO class2 FROM class --新表不存在(即复制数据的同时创建与旧表相同结构的新表):
copy2
INSERTINTO class2(name,teacher_name)SELECT name,teacher_name FROM class
--新表已存在,从旧表从插入选择的数据(注意:表的[主键]不要复制,因为具有唯一性,否则:Sql Server提示“当 IDENTITY_INSERT 设置为 OFF 时,不能为表 'xxxxxx' 中的标识列插入显式值”)
增插入数据INSERT INTO class (name,teacher_name) VALUES ('软件班','张三')INSERT INTO class (name,teacher_name) VALUES ('软件2班',NULL)INSERT INTO class VALUES('计算机应用班','李四')INSERT INTO class VALUES('网络班','王五')向学生表中插入数据INSERT INTO student VALUES('张三','男',19,1,'06