SQL Server 二进制和大值数据SQL Server Binary and Large-Value Data

SQL Server 提供 max 说明符,它可扩展 varcharnvarcharvarbinary 数据类型的存储容量。SQL Server provides the max specifier, which expands the storage capacity of the varchar, nvarchar, and varbinary data types. varchar(max)nvarchar(max)varbinary(max)统称为大值数据类型varchar(max), nvarchar(max), and varbinary(max) are collectively called large-value data types. 您可以使用大值数据类型来存储最大为 2^31-1 个字节的数据。You can use the large-value data types to store up to 2^31-1 bytes of data.

SQL Server 2008 引入了 FILESTREAM 属性,该属性不是一种数据类型,而是一种可在列上定义的属性,因而允许将大值数据存储在文件系统上而不是存储在数据库中。SQL Server 2008 introduces the FILESTREAM attribute, which is not a data type, but rather an attribute that can be defined on a column, allowing large-value data to be stored on the file system instead of in the database.

本节内容In This Section

在 ADO.NET 中修改大值 (max) 数据Modifying Large-Value (max) Data in ADO.NET
说明如何使用大值数据类型。Describes how to work with the large-value data types.

FILESTREAM 数据FILESTREAM Data
描述如何使用在 SQL Server 2008 中通过 FILESTREAM 属性存储的大值数据。Describes how to work with large-value data stored in SQL Server 2008 with the FILESTREAM attribute.

请参阅See also