如何在Powershell中获取SQL存储过程的内容？

Install-Module -Name SqlServer

$Server = "your_server_name"
$Database = "your_database_name"
$Username = "your_username"
$Password = "your_password"

$ConnectionString = "Server=$Server;Database=$Database;User ID=$Username;Password=$Password;"
$Connection = New-Object System.Data.SqlClient.SqlConnection($ConnectionString)
$Connection.Open()

$Query = "SELECT definition FROM sys.sql_modules WHERE object_id = OBJECT_ID('your_stored_procedure_name')"
$Command = New-Object System.Data.SqlClient.SqlCommand($Query, $Connection)
$Reader = $Command.ExecuteReader()

while ($Reader.Read()) {
    $StoredProcedureContent = $Reader["definition"]
    Write-Host $StoredProcedureContent
}

$Reader.Close()

$Connection.Close()