分区表
摘要：
分区表的基本操作和通过分区切换来操作分区表1.创建数据库和添加文件组IF DB_ID('TestDB_PT') IS NOT NULL DROP DATABASE TestDB_PT;GOCREATE DATABASE TestDB_PTONPRIMARY(Name=TestDB_PT,FILENAME='C:\DB\TestDB_PT\TestDB_PT.mdf',SIZE=2MB,MAXSIZE=1024MB,FILEGROWTH=10MB)LOG ON(Name=TestDB_PT_LOG,FILENAME='C:\DB\TestDB_PT\Tes 阅读全文
posted @ 2013-05-22 15:51 Leon_He 阅读(696) 评论(0) 推荐(0) 编辑