Advertisement
private775

[PS] SQL - invoke sql query

Oct 29th, 2018
353
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # invoke sql cmd
  2. [System.Reflection.Assembly]::LoadWithPartialName("System.Data") | Out-Null
  3. [System.Reflection.Assembly]::LoadWithPartialName("System.Data.SqlClient") | Out-Null
  4.  
  5. function Invoke-SqlcmdCustom {
  6.     [CmdletBinding()]
  7.     Param(
  8.         [parameter(Mandatory=$false)]
  9.         [string]$ServerInstance,
  10.         [parameter(Mandatory=$false)]
  11.         [string]$Database,
  12.         [parameter(Mandatory=$false)]
  13.         [string]$Query
  14.     )
  15.     $connstr = "Server=$($ServerInstance);Database=$($Database);Trusted_Connection=True;"
  16.     $conn = new-object System.Data.SqlClient.SqlConnection($connstr)
  17.     $conn.Open()
  18.     $cmd = new-object  System.Data.SqlClient.SqlCommand($Query, $conn)
  19.     $dt = new-object System.Data.DataTable
  20.     $dt.Load($cmd.ExecuteReader())
  21.     $cmd.Dispose()
  22.     $conn.Close()
  23.     $conn.Dispose()
  24. return $dt.Rows
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement