#* FileName:  Run-SQLQuery  
#*=============================================================================
#* FUNCTION LISTINGS
#*=============================================================================
#* Function: 	Run-SQLQuery
#* Created:     [10/17/07]
#* Author:     	Steven Murawski
#* Arguments:  	SQL query as a string or file name
#*=============================================================================
#* Purpose:    
#*             
#*                           
#*=============================================================================
function Run-SQLQuery (
	[switch] $file,
	[string]$query = $(throw "SQL Query Needed!")
	)
{
	$SqlServer = 'Your SQL Server Here'
	$SqlCatalog = 'Target Database'
	$SqlQuery = ""
	if ($file)
		{get-content $query | % {$SQLQuery += (" "+($_.Trim())+" ")}}
	else {$SqlQuery = $query}
		
	$SqlUser = 'SQL User'
	$SqlPass = 'SQL Password'
	$SqlConnString = "Server = $SqlServer; Database = $SqlCatalog; user = $SqlUser; password = $SqlPass"


	$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
	$SqlConnection.ConnectionString = $SqlConnString

	$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
	$SqlCmd.CommandText = $SqlQuery
	$SqlCmd.Connection = $SqlConnection

	$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
	$SqlAdapter.SelectCommand = $SqlCmd

	$DataSet = New-Object System.Data.DataSet
	$a = $SqlAdapter.Fill($DataSet)

	$SqlConnection.Close()
	Clear
	
	if ($a -gt 0)
		{
			$DataRows = $DataSet.Tables[0].Rows
			$DataRows
		}
	else 
		{
			"No Results"
		}
}