SQL Server 通过T_sql语句向其中一次填入一条数据或一次填入多条数据的方式填充数据

这篇文章主要为大家详细介绍了SQL Server 通过T_sql语句向其中一次填入一条数据或一次填入多条数据的方式填充数据，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

代码如下:

 
create database TestSchool 
on primary 
( 
name='TestSchool', 
filename='F:\SQL Server\TestSchool.mdf', 
size=10mb, 
filegrowth=10, 
maxsize=100mb 
) 
log on 
( 
name='TestSchool_log', 
filename='F:\SQL Server\TestSchool_log.ldf' 
) 

create table TblStudent 
( 
studentId int identity(1,1) primary key, 
tScoreId int not null, 
sName nvarchar(50) not null, 
sAge int not null, 
sNo numeric(18,0),--身份证号，十八位数字，小数位0 
sEmail varchar(50), 
sGender bit default(1), 
sBirthday datetime 
) 

select * from TblStudent 
truncate table TblStudent 

insert into TblStudent 
select 1,'刘备',20,123456789012345678,'123@163.com',1,'1987-5-6' union 
select 1,'关羽',19,123456789012345671,'1sfdsf3@163.com',1,'1988-8-6' union 
select 1,'张飞',18,123456789012345672,'12sfsd3@163.com',1,'1989-5-19' union 
select 4,'曹操',22,123456789012345673,'12sf3@163.com',1,'1985-12-6' union 
select 4,'夏侯惇',22,123456789012345674,'1ff23@163.com',1,'1985-3-6' union 
select 4,'华佗',50,12345678901234565,'12ff3@163.com',1,'1957-1-16' union 
select 4,'甄姬',18,12345678901234565,'12f3@163.com',0,'1989-8-8' 

create table TblScore 
( 
tScoreId int identity(1,1) primary key, 
studentId int not null, --学生id，外键 
tEnglish float, 
tMath float 
) 

select * from TblScore 
truncate table TblScore 

insert into TblScore 
select 1,90,97 union 
select 2,90,70 union 
select 3,59,100 union 
select 4,100,80 union 
select 5,60,96 union 
select 6,0,100 union 
select 7,80,60 

create table TblTeacher 
( 
tTId int identity(1,1) primary key, 
tTName nvarchar(50) not null, 
tTGender bit default(1), 
tTAge int, 
tTSalary money, 
tTBirthday datetime 
) 

select * from TblTeacher 

insert into TblTeacher 
select '商炳奇',1,22,10000,'1991-10-30' union 
select '刘祎',0,22,10000,'1991-11-06' union 
select '耿宇丹',0,21,10000,'1992-12-30' union 
select '张少丹',0,22,10000,'1991-6-6' union 
select '王静静',0,22,10000,'1991-6-6' union 
select '段琳琳',0,22,10000,'1991-6-6' union 
select '杨巧巧',0,21,10000,'1991-6-6' 

注：关于SQL Server 通过T_sql语句向其中一次填入一条数据或一次填入多条数据的方式填充数据的内容就先介绍到这里，更多相关文章的可以留意