Codebase list poshc2 / e3f30ac resources / modules / Invoke-SqlQuery.ps1
e3f30ac

Tree @e3f30ac (Download .tar.gz)

Invoke-SqlQuery.ps1 @e3f30ac — raw · history · blame 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<#
.Synopsis
   Invoke-SqlQuery
.DESCRIPTION
   Invoke-SqlQuery
.EXAMPLE
   Invoke-SqlQuery -Sqlserver 10.150.10.150 -Username sa -Password sa
#>
function Invoke-SqlQuery {

  param (
    [String]$ConnectionString,
    [String]$Sqlserver,
    [String]$Username,
    [String]$Password,
    [String]$Catalog,
    [String]$Database,
    [String]$Query
  )
  if (!$Database){
    $Database = ";"
  } else {
    $Database = "$Database;"
  }

  if (!$Catalog){
    $Catalog = "Initial Catalog=Master;"
  } else {
    $Catalog = "Initial Catalog=$Catalog;"
  }

  if ($Username -and $Password){
    $Authentication = "User Id=$Username;Password=$Password;"
  } else {
    $Authentication = "Integrated Security=True;"
  }

  if (!$query){
    $Query = 'SELECT @@version';
  }

  $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
  $SqlConnection.ConnectionString = "Data Source=$Sqlserver;$Catalog$Authentication$Database"
  $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
  $SqlCmd.CommandText = $Query
  $SqlCmd.Connection = $SqlConnection
  $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
  $SqlAdapter.SelectCommand = $SqlCmd
  $DataSet = New-Object System.Data.DataSet
  $SqlAdapter.Fill($DataSet)
  $DataSet.Tables[0]            

}