共用方式為


MaxSize Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The MaxSize property returns the greatest length of a data type in bytes, or the precision of the type.

語法

object.MaxSize

Parts

  • object
    Expression that evaluates to an object in the Applies To list

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetMaxSize(LPLONG pRetVal);

備註

For binary and character data types, the MaxSize property returns the greatest number of bytes required to store a string of the type. For example, a user-defined data type defined as varchar(22) requires 22 bytes. The number of characters contained in the string is determined by the mix of single and multibyte characters within it.

For the fixed-precision, numeric data types, the MaxSize property returns the maximum precision of the type.

For all other referenced data types, the MaxSize property returns the number of bytes required to store a value of the type in a Microsoft SQL Server structure representing the type.