復制代碼 代碼如下:
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,'夏侯
主站蜘蛛池模板：
苏尼特左旗|
灵川县|
东乡县|
咸宁市|
临西县|
翁源县|
隆尧县|
县级市|
太保市|
临江市|
天台县|
扬州市|
嘉祥县|
磐安县|
静乐县|
翁牛特旗|
武汉市|
家居|
应城市|
曲周县|
阜宁县|
克东县|
二连浩特市|
漠河县|
澜沧|
宁武县|
财经|
文水县|
霞浦县|
盐城市|
花莲县|
和政县|
亚东县|
尖扎县|
仁怀市|
夹江县|
宣汉县|
龙井市|
宁津县|
淮阳县|
筠连县|