truncate table Student --清空数据库中的数据
insert into 插入
Student 指 插入的学生表
insert into [表名] (表的列名)values(插入的值)
*注意:*插入的值要和表的列名相对应如不想插入该列指可用空代替
如下所示:
insert into Student(StudentNo,LoginPwd,StudenntName,Sex,GradeId,Phone,[Address],BornDate,Email)
values('S1200902001','zhangsan','张三','男',1,' ','解放路','1990-01-01','zhangsan@126')
insert into Student(studentNo,LoginPwd,StudenntName,Sex,GradeId,Phone,[Address],BornDate,Email)
values('S1200902002','lisi89','李四','男',1,'13812345678','长江路','1989-02-01',null)
更多推荐
sql server插入语句
发布评论