Set-AzSynapseSqlScript
Membuat atau memperbarui skrip SQL di ruang kerja.
Sintaks
Set-AzSynapseSqlScript
-WorkspaceName <String>
[-Name <String>]
-DefinitionFile <String>
[-ResultLimit <Int32>]
[-FolderPath <String>]
[-Description <String>]
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSynapseSqlScript
-WorkspaceName <String>
-SqlPoolName <String>
-SqlDatabaseName <String>
[-Name <String>]
-DefinitionFile <String>
[-ResultLimit <Int32>]
[-FolderPath <String>]
[-Description <String>]
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSynapseSqlScript
-WorkspaceObject <PSSynapseWorkspace>
[-Name <String>]
-DefinitionFile <String>
[-ResultLimit <Int32>]
[-FolderPath <String>]
[-Description <String>]
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Set-AzSynapseSqlScript
-WorkspaceObject <PSSynapseWorkspace>
-SqlPoolName <String>
-SqlDatabaseName <String>
[-Name <String>]
-DefinitionFile <String>
[-ResultLimit <Int32>]
[-FolderPath <String>]
[-Description <String>]
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Deskripsi
Cmdlet Set-AzSynapseSqlScript membuat atau memperbarui skrip SQL di ruang kerja.
Contoh
Contoh 1
Set-AzSynapseSqlScript -WorkspaceName ContosoWorkspace -DefinitionFile "C:\\samples\\sqlscript.sql"
Perintah ini membuat atau memperbarui skrip SQL dari file skrip SQL sqlscript.sql di ruang kerja bernama ContosoWorkspace.
Contoh 2
$ws = Get-AzSynapseWorkspace -Name ContosoWorkspace
$ws | Set-AzSynapseSqlScript -DefinitionFile "C:\\samples\\sqlscript.sql"
Perintah ini membuat atau memperbarui skrip SQL dari file skrip SQL sqlscript.sql di ruang kerja bernama ContosoWorkspace.
Contoh 3
Set-AzSynapseSqlScript -WorkspaceName ContosoWorkspace -DefinitionFile "C:\\samples\\sqlscript.sql" -SqlPoolName Contososqlpool -SqlDatabaseName Contosodatabase
Perintah ini membuat atau memperbarui skrip SQL dari file skrip SQL sqlscript.sql yang terhubung ke ContosoSqlPool dan menggunakan database bernama Contosodatabase di ruang kerja bernama ContosoWorkspace.
Parameter
-AsJob
Jalankan cmdlet di latar belakang
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefinitionFile
Jalur file SQL.
Type: | String |
Aliases: | File |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Description
Deskripsi skrip SQL.
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-FolderPath
Folder tempat skrip SQL ini berada. Jika menentukan jalur multi-tingkat seperti [rootFolder/subFolder], SqlScript akan muncul di tingkat bawah. Jika tidak ditentukan, skrip SQL ini akan muncul di tingkat akar.
Type: | String |
Aliases: | FolderName |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
Nama skrip sql.
Type: | String |
Aliases: | SqlScriptName |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResultLimit
Batas hasil, '-1' tanpa batas.
Type: | Int32 |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SqlDatabaseName
Database mana yang akan digunakan skrip sql.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SqlPoolName
Kumpulan sql mana yang akan disambungkan oleh skrip sql.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WorkspaceName
Nama ruang kerja Synapse.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WorkspaceObject
objek input ruang kerja, biasanya melewati alur.
Type: | PSSynapseWorkspace |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
Input
Output
Link Terkait
Azure PowerShell
Saran dan Komentar
https://aka.ms/ContentUserFeedback.
Segera hadir: Sepanjang tahun 2024 kami akan menghentikan penggunaan GitHub Issues sebagai mekanisme umpan balik untuk konten dan menggantinya dengan sistem umpan balik baru. Untuk mengetahui informasi selengkapnya, lihat:Kirim dan lihat umpan balik untuk