如何在SQL Server2008中存储超过8000个字符并分配较大的连接字符串？

CREATE TABLE ConnectionStrings (
    ID INT PRIMARY KEY,
    ConnectionString VARCHAR(MAX)
);

INSERT INTO ConnectionStrings (ID, ConnectionString)
VALUES (1, 'Your connection string here');

EXEC sp_configure 'filestream_access_level', 2;
RECONFIGURE;

ALTER DATABASE YourDatabase
ADD FILEGROUP YourFileGroup CONTAINS FILESTREAM;

ALTER DATABASE YourDatabase
ADD FILE (
    NAME = YourFileGroupFile,
    FILENAME = 'C:\YourFileGroupFile'
)
TO FILEGROUP YourFileGroup;

CREATE TABLE ConnectionStrings (
    ID INT PRIMARY KEY,
    ConnectionString VARBINARY(MAX) FILESTREAM
);

INSERT INTO ConnectionStrings (ID, ConnectionString)
VALUES (1, CAST('Your connection string here' AS VARBINARY(MAX)));