共用方式為

ScriptingOptions.FileName 屬性

  • 發行項

Gets or sets the name of the file to which the generated script is output.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Property FileName As String 
    Get 
    Set
'用途
Dim instance As ScriptingOptions 
Dim value As String 

value = instance.FileName

instance.FileName = value

public string FileName { get; set; }

public:
property String^ FileName {
    String^ get ();
    void set (String^ value);
}

member FileName : string with get, set

function get FileName () : String 
function set FileName (value : String)

屬性值

型別：System.String
A String value that specifies the name of the file to which the generated script is output.

範例

The following code example sets the name of the scripts output file.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\SampleFileName.sql"

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\SampleFileName.sql"

請參閱

參考

ScriptingOptions 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

指令碼