/C++/Powershell script query mssql windows authentication

Powershell script query mssql windows authentication

function global:SelectAllUsers()
{
    Read-Query -ConnectionString 'Server=localhost;Database=Ulysses;UID=EMEA\XJ193;PWD=somepassword;Integrated Security=true;' `
        -Query "SELECT * FROM Users" `
        -Action {
            echo "I can take an action here"
        }
}

function Read-Query
{
    param (
        [Parameter(Mandatory=$true)]
        [string]$ConnectionString,

        [Parameter(Mandatory=$true)]
        [string]$Query,

        [Parameter(Mandatory=$true)]
        [scriptblock]$Action
    )

    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $SqlConnection.ConnectionString = $ConnectionString
    $SqlConnection.Open()
    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
    $SqlCmd.CommandText = $Query
    $SqlCmd.Connection = $SqlConnection
    $reader = $SqlCmd.ExecuteReader()

    while ($reader.Read())
    {
        $x = $null
        $x = @{}

        for ($i = 0; $i -lt $reader.FieldCount; ++$i)
        {
            $x.add($reader.GetName($i), $reader[$i])
        }

        Invoke-Command -ScriptBlock $action -ArgumentList $x
    }

    $SqlConnection.Close()
}



SelectAllUsers

Source: stackoverflow.com

Similar codes

-1 vote125 views1 answer
C++ filesystem remove file
C++
1 vote119 views1 answer
C++ ->
C++
5 votes117 views4 answers
C++ remove whitespace from string
C++
0 vote124 views1 answer
C++ pass ofstream as argument
C++
0 vote145 views1 answer
Mingw32/bin/ld.exe: C:\Users\mfrom\AppData\Local\Temp\ccSKcRks.o:PizzaPi.cpp:(.text$_ZN5PizzaC2Ev[__ZN5PizzaC2Ev]+0xa): undefined reference to `vtable for Pizza' collect2.exe: error: ld returned 1 exit status
C++
46 votes159 views3 answers
All data types in C++
C++
1 vote134 views1 answer
How to find the individual letters of a string c++
C++
4 votes158 views1 answer
Deep copy c++
C++
0 vote126 views1 answer
Recursive power in c++
C++
0 vote145 views1 answer
Check if cin got the wrong type
C++