鍒涘缓鏁版嵁搴撶殑
SQL
璇彞锛?/p>
1
create database stuDB
2
on primary --
榛樿灏卞睘浜?/p>
primary
鏂囦欢缁?/p>
,
鍙渷鐣?/p>
3
(
4
/*--
鏁版嵁鏂囦欢
鐨勫叿浣撴弿杩?/p>
--*/
5
name=
'stuDB_data'
, --
涓绘暟鎹枃浠剁殑閫昏緫鍚嶇О
6
filename=
'D:\stuDB_data.mdf'
, --
涓绘暟鎹枃浠剁殑鐗╃悊鍚嶇О
7
size=5mb, --
涓绘暟鎹枃浠剁殑鍒濆澶у皬
8
maxsize=100mb, --
涓绘暟鎹枃浠跺闀跨殑鏈�澶у�?/p>
9
filegrowth=
15
%--
涓绘暟鎹枃浠剁殑澧為暱鐜?/p>
10
)
11
log on
12
(
13
/*--
鏃ュ織鏂囦欢
鐨勫叿浣撴弿杩?/p>
,
鍚勫弬鏁板惈涔夊悓涓?/p>
--*/
14
name=
'stuDB_log'
,
15
filename=
'D:\stuDB_log.ldf'
,
16
size=2mb,
17
filegrowth=1mb
18
)
閭ｄ箞濡備綍鍒犻櫎杩欎釜鏁版嵁搴撳憿锛?/p>
SQL Server
灏嗘暟鎹簱鐨勬竻鍗曞瓨鏀惧湪
master
绯荤粺鏁版嵁搴撶殑
sysdatabases
琛ㄤ腑锛屽彧闇�瑕佹煡鐪嬭琛ㄦ槸鍚﹀瓨鍦ㄤ簬璇ユ暟鎹簱涓氨鍙互
浜嗭紝璇彞濡備笅锛?/p>
use master --
璁剧疆褰撳墠鏁版嵁搴撲负
master,
浠ヤ究璁块棶
sysdatabases
琛?/p>
go
if
exists(select * from sysdatabases
where
name=
'stuDB'
)
drop database stuDB
go
鍒涘缓琛ㄥ拰鍒犻櫎琛ㄧ殑
SQL
璇彞濡備笅锛?/p>
use StuDB
go
if
exists(select * from sysobjects
where
name=
'stuMarks'
)
drop table stuMarks
create table stuMarks
(
ExamNo
int
identity(
1
,
1
) primary key,
stuNo
char
(
6
) not
null
,
writtenExam
int
not
null
,
LabExam
int
not
null