Microsoft SQL Sever 2000 Basic Operation.docVIP

Microsoft SQL Sever 2000 Basic Operation 1) -- ============================================= -- Basic Create Database Template -- ============================================= IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = N学生管理) DROP DATABASE 学生管理 GO CREATE DATABASE 学生管理 GO 使用企业管理器和数据库创建向导创建数据库 2)T-SQL语句创建数据库 -- ============================================= -- Create database on mulitple file groups -- ============================================= IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = ‘zhangping’ DROP DATABASE zhangping GO CREATE DATABASE zhangping----------------创建名字为zhangping的数据库 ON PRIMARY ( NAME = zhangping1, ------主文件组包含主数据文件,文件大小为5M最大100MB 按照10%的增长 FILENAME = E:\Test\zhangping1.mdf, SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 10%), ( NAME = zhangping2,---- ------辅助数据文件,文件大小为5M最大100MB 按照10%的增长 FILENAME = E:\Test\zhangping2.ndf, SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 10%) LOG ON ( NAME = zhangping_log, FILENAME = E:\Test\zhangping_log.ldf, SIZE = 2MB, MAXSIZE = 35MB, FILEGROWTH = 1MB) GO -- ============================================= -- Create database on mulitple file groups -- ============================================= IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = zhangping) DROP DATABASE zhangping GO CREATE DATABASE zhangping ON PRIMARY ( NAME = zhangping1, FILENAME = E:\Test\zhangping1.mdf, SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 10%), ( NAME = zhangping2.mdf, FILENAME = E:\Test\zhangping2.ndf, SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 10%), FILEGROUP zhangpinggroup ( NAME = zhangping3, FILENAME = E:\Test\zhangping3.ndf, SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 10%), ( NAME = zhangping4, FILENAME = E:\Test\zhangping4.ndf, SIZE = 5M