详细讲解有关SQL Server的几个简单示例

create table teachers(id int primary key not 
null identity(10000,100),tea_name varchar(50), 
tea_age int default 20) 
create procedure insert1000teachers 
as 
declare @tea_name varchar(50) 
declare @tea_age int 
declare @index int 
declare @count int 
set @index=1 
set @count=100 
while @index<@count 
begin 
set @tea_age=30*rand() 
set @tea_name='teacher' 
set @tea_name=@tea_name+convert(varchar,@index) 
insert into teachers(tea_name,tea_age) 
values(@tea_name,@tea_age) 
set @index=@index+1 
end

create database test1  
on 
primary 
( 
name=t1_dat, 
filename='d:\test_database\1\t1_dat.mdf', 
size=1, 
filegrowth=15%, 
maxsize=50 
)，
( 
name=t2_dat, 
filename='d:\test_database\1\t2_dat.ndf', 
size=1, 
maxsize=UNLIMITED, 
filegrowth=1 
) 
log on 
( 
name=t_log, 
filename='d:\test_database\1\t_log.ldf', 
size=1, 
maxsize=UNLIMITED, 
filegrowth=1 
)