Compartir a través de

  • Artículo

BatchSize Propiedad

Gets or sets the number of statements after which to script batch terminator.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Property BatchSize As Integer
    Get
    Set
'Uso
Dim instance As ScriptingOptions
Dim value As Integer

value = instance.BatchSize

instance.BatchSize = value

public int BatchSize { get; set; }

public:
property int BatchSize {
    int get ();
    void set (int value);
}

member BatchSize : int with get, set

function get BatchSize () : int
function set BatchSize (value : int)

Valor de la propiedad

Tipo: System. . :: . .Int32
A Int32 value that indicates the number of insert statements that are scripted before a batch terminator is inserted.

Comentarios

The default for this property is 1.

Ejemplos

The following code example sets the scripts batch size to 10.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.BatchSize = 10

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.BatchSize = 10