sqlserver2008 文件流

/**
说明：
1、启用数据库实例FILESTREAM：
   1）在SQL Server配置管理器中打开SQL Server数据库引擎的属性窗口，切换到FILESTREAM选项卡，选中“针对Transact-SQL访问启用FILESTREAM”等三个复选框，然后单击“

确定”按钮保存对FILESTREAM的设置。
   2）打开SQL Server Management Studio连接到数据库实例，右击数据库实例，选择“属性”选项，切换的“高级”选项页，在文件流访问级别下拉列表框中选择“已启用完全

访问”选项。
2、手动创建数据库COSTSW；
3、指定以下文件组根路径，确保位于NTFS文件系统磁盘；
4、执行以下代码。
**/

ALTER DATABASE [COSTSW]
ADD FILEGROUP [COSTSWGroup] CONTAINS FILESTREAM
GO

ALTER DATABASE [COSTSW]
ADD FILE ( NAME = N'FileStream',FILENAME = N'D:docFileStream') --文件组路径
TO FILEGROUP [COSTSWGroup]
GO


/****** Object:  Table [dbo].[Files]    Script Date: 08/05/2010 14:45:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Files](
	[ID] [int] NOT NULL,[FileID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,[Title] [nvarchar](500) NOT NULL,[FileContent] [varbinary](max) FILESTREAM  NULL,--文件实体
	[Extension] [nvarchar](20) NOT NULL,[Size] [int] NOT NULL,[UploadDate] [datetime] NOT NULL,[SystemUserID] [int] NOT NULL,CONSTRAINT [PK_Files] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF,STATISTICS_NORECOMPUTE  = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS  = ON,ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] FILESTREAM_ON 

[COSTSWGroup],UNIQUE NONCLUSTERED 
(
	[FileID] ASC
)WITH (PAD_INDEX  = OFF,ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] FILESTREAM_ON [COSTSWGroup]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'编号',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Files',@level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'GUID编号',@level2name=N'FileID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'标题',@level2name=N'Title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'文件数据',@level2name=N'FileContent'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'扩展名',@level2name=N'Extension'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'文件大小(单位:字节)',@level2name=N'Size'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'上传时间',@level2name=N'UploadDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'上传管理员编号',@level2name=N'SystemUserID'
GO

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!