Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # invoke sql cmd
- [System.Reflection.Assembly]::LoadWithPartialName("System.Data") | Out-Null
- [System.Reflection.Assembly]::LoadWithPartialName("System.Data.SqlClient") | Out-Null
- function Invoke-SqlcmdCustom {
- [CmdletBinding()]
- Param(
- [parameter(Mandatory=$false)]
- [string]$ServerInstance,
- [parameter(Mandatory=$false)]
- [string]$Database,
- [parameter(Mandatory=$false)]
- [string]$Query
- )
- $connstr = "Server=$($ServerInstance);Database=$($Database);Trusted_Connection=True;"
- $conn = new-object System.Data.SqlClient.SqlConnection($connstr)
- $conn.Open()
- $cmd = new-object System.Data.SqlClient.SqlCommand($Query, $conn)
- $dt = new-object System.Data.DataTable
- $dt.Load($cmd.ExecuteReader())
- $cmd.Dispose()
- $conn.Close()
- $conn.Dispose()
- return $dt.Rows
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement