Propriété ScriptingOptions.BatchSize
Gets or sets the number of statements after which to script batch terminator.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Property BatchSize As Integer
Get
Set
'Utilisation
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)
Valeur de propriété
Type : System.Int32
A Int32 value that indicates the number of insert statements that are scripted before a batch terminator is inserted.
Notes
The default for this property is 1.
Exemples
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
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo