1.  啟用 SQL Server 2008 Filestream 功能

a. 開始/所有程序/SQL Server 2008/Configuration Tools/SQL Server Configuration
b. 選中Service，右鍵屬性
c. 切換至Log On選項(xiàng)卡，設(shè)置如下圖

    
d. 切換至FileStream選項(xiàng)卡，設(shè)置如下圖

    
e. 點(diǎn)擊OK結(jié)束設(shè)置

f. 在Management Studio中查看數(shù)據(jù)庫的屬性

2.  創(chuàng)建數(shù)據(jù)庫和數(shù)據(jù)表

--Create Database
CREATE DATABASE FSTtttt
ON
PRIMARY ( 
	NAME = FSTtttt,
	FILENAME = 'E:\Database\FSTtttt.mdf'
), FILEGROUP FSG00001 CONTAINS FILESTREAM ( 
	NAME = FSTtttt_fs,
	FILENAME = 'E:\Database\FSTtttt_fs'
)

LOG ON ( 
	NAME = FSTtttt_log,
	FILENAME = 'E:\Database\FSTtttt_log.ldf'
)
GO

USE [FSTtttt]
GO

--Create Table
CREATE TABLE [dbo].[FSTest](
	[Id] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[FileName] [nvarchar](64) NULL,
	[FileData] [varbinary](max) FILESTREAM  NULL, 
UNIQUE NONCLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] FILESTREAM_ON [FSG00001]
GO

3.  注意事項(xiàng)

當(dāng)數(shù)據(jù)庫被備份一次之后，使用 Delete 無法刪除對(duì)應(yīng)的文件，這時(shí)可以修改數(shù)據(jù)庫的恢復(fù)模式為簡單(Simple)，執(zhí)行以下腳本即可

ALTER DATABASE FSTtttt SET RECOVERY SIMPLE
GO

CHECKPOINT
GO

ALTER DATABASE FSTtttt SET RECOVERY FULL
GO

4.  示例下載

我的資源中存儲(chǔ)讀取圖片的示例