--2.创建文件组
ALTER DATABASE [DW_AUDIT_TT_PIS]
ADD FILEGROUP [FG_CCS_FILE]
--3.创建文件
ALTER DATABASE [DW_AUDIT_TT_PIS]
ADD FILE
(NAME = N'FG_CCS_FILE_01',FILENAME = N'D:\DATA\FG_CCS_FILE_01_data.ndf',SIZE = 20000MB, FILEGROWTH = 10000MB )
TO FILEGROUP [FG_CCS_FILE]
ALTER DATABASE [DW_AUDIT_TT_PIS]
ADD FILE(NAME = N'FG_CCS_FILE_02',FILENAME = N'D:\DATA\FG_CCS_FILE_02_data.ndf',SIZE = 20000MB, FILEGROWTH = 10000MB )
TO FILEGROUP [FG_CCS_FILE];
SELECT COUNT(1) FROM xxx_FILE_backup20181101(NOLOCK) --36378791
CREATE TABLE [dbo].[xxx_file_test](
[plantcode] [nvarchar](50) NULL,
[xxx01] [nvarchar](255) NULL,
[xxx02] [nvarchar](255) NULL,
[xxx021] [nvarchar](255) NULL,
[xxx024] [numeric](18, 3) NULL,
[xxx026] [nvarchar](255) NULL,
[xxx03] [nvarchar](255) NULL,
[xxx031] [nvarchar](255) NULL,
[xxx036] [nvarchar](255) NULL,
[xxx04] [nvarchar](255) NULL,
[xxx05] [nvarchar](255) NULL,
[xxx06] [date] NULL,
[xxx07] [date] NULL,
[xxx08] [nvarchar](255) NULL,
[xxx09] [nvarchar](10) NULL,
[xxx10] [numeric](13, 3) NULL,
[xxx11] [nvarchar](10) NULL,
[xxx12] [numeric](16, 8) NULL,
[xxx13] [nvarchar](255) NULL,
[xxx14] [nvarchar](255) NULL,
[xxx17] [nvarchar](255) NULL,
[xxx43] [nvarchar](255) NULL,
[xxx905] [nvarchar](255) NULL,
[SERVER] [nvarchar](50) NULL,
[ODBC] [nvarchar](50) NULL,
[SyncDate] [datetime] NULL
) ON [FG_CCS_FILE]
GO
ALTER TABLE [dbo].[xxx_file_test] ADD CONSTRAINT [DF_xxx_file_SyncDate2] DEFAULT (getdate()) FOR [SyncDate]
GO
select * from xxx_file_test
--EXEC sp_rename 'xxx_file_test1','xxx_file'
--insert into xxx_file_test1
select *
from xxx_file;