USE master
GO
CREATE DATABASE testbase2
ON
PRIMARY
(NAME = prim_sub_dat1,
FILENAME = 'G:\SQL SERVER2000\prim_sub_dat.mdf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROWTH = 20%),
(NAME = prim_sub_dat2,
FILENAME = 'G:\SQL SERVER2000\prim_sub_dat.ndf'
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROWTH = 20% ),
FILEGROUP Grouptest1
(NAME = group1_sub1,
FILENAME= 'G:\SQL SERVER2000\group1_sub1_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP = 5MB ),
(NAME = group1_sub2,
FILENAME = 'G:\SQL SERVER2000\group1_sub2_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,)
FILEGROUP Grouptest2
(NAME = group2_sub1,
FILENAME = 'G:\SQL SERVER2000\group2_sub1_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP = 15%),
(NAME = group2_sub2,
FILENAME = 'G:\SQL SERVER2000\group2_sub2_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP =15% )
LOG ON
( NAME = testbase2_log,
FILENMAE ='G:SQL SERVER2000\testbase2_log_file.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROUP = 5MB )
GO
熟悉SQL SERVER 2000的数据库管理员都知道，其DTS可以进行数据的导入导出，其实，我们也可以使用Transact-SQL语句进行导入导出操作。在Transact-SQL语句中，我们主要使用OpenDataSource函数、OPENROWSET 函数，关于函数的详细说明，请参考SQL联机帮助。利用下述方法，可以十分容易地实现SQL SERVER、ACCESS、EXCEL数据转换� ......
