在数据库boris中创建Student表
use boris
IF OBJECT_ID('Student') IS NOT NULL
DROP TABLE Student
CREATE TABLE Student
(Sname nvarchar(50) null, Ssex nvarchar(50) null,Sage int null)
insert into Student
select '张三','男','14' union all
select '李四','女','15'union all
select '王五','男','16'
select * from Student
结果显示:
Sname Ssex Sage
-------------------------------------------------- -------------------------------------------------- -----------
张三 男 14
李四 女 15
王五 男 16
(3 行受影响)