sql - 从 SQL 脚本返回变量到 PowerShell

Question

我有一个问题，我一直无法找到......

我想从 SQL 脚本返回值到 powershell。

-MyScript.sql

    DECLARE @var VARCHAR(20);
    SET @var = 'databaseName';

-我的 PowerShell

    $serverInstance='Server'
    $inputFile='C:\Users\xxx\Desktop\xxx\MyScript.sql'
    $user='user'
    $pass='pass'

    $splat=@{
        ServerInstance=$serverInstance
        InputFile=$InputFile
        U=$user
        P=$pass
    }

    $result= @(Invoke-Sqlcmd @splat -ErrorAction Stop)

    #From here it's an example because don't know how
    $result= @var  #The return from .SQL Script @var = 'databaseName'
    If $result = "databaseName"
       #Invoke-Sqlcmd with other actions

帮助！

标签： sqlpowershellreturn