Condividi tramite

  • Articolo

Proprietà VarCharMax

Gets a data type that specifies the VarCharMax definition used in the data type.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Shared ReadOnly Property VarCharMax As DataType
    Get
'Utilizzo
Dim value As DataType

value = DataType.VarCharMax

public static DataType VarCharMax { get; }

public:
static property DataType^ VarCharMax {
    DataType^ get ();
}

static member VarCharMax : DataType

static function get VarCharMax () : DataType

Valore proprietà

Tipo: Microsoft.SqlServer.Management.Smo. . :: . .DataType
A DataType object value that specifies a VarCharMax definition in the data type.

Osservazioni

This data type allows storage of up to a maximum of 2GB of data. You can use the VarCharMax data type as a parameter in stored procedures and string functions. However, you cannot use this data type in the key column of an index.

Esempi

Visual Basic

Dim dt As DataType
dt = New DataType(SqlDataType.VarCharMax)

PowerShell

$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::VarCharMax)