Querying Sql Server - Revision history

George2 at 18:32, 27 August 2014

2014-08-27T18:32:45Z

George2 at 18:29, 27 August 2014

2014-08-27T18:29:57Z

George2 at 18:28, 27 August 2014

2014-08-27T18:28:46Z

George2 at 18:28, 27 August 2014

2014-08-27T18:28:18Z

George2: Created page with "'''Some examples from Google'''

$SQLDBName = "MyDBName" $SqlQuery = "select * from authors WHERE Name = 'John Simon'" $SqlConnection = Ne..."

2014-08-27T18:26:01Z

Created page with "'''Some examples from Google'''<br> <br> <source lang="powershell"> $SQLDBName = "MyDBName" $SqlQuery = "select * from authors WHERE Name = 'John Simon'" $SqlConnection = Ne..."

New page

'''Some examples from Google'''<br>
<br>
<source lang="powershell">
$SQLDBName = "MyDBName"
$SqlQuery = "select * from authors WHERE Name = 'John Simon'"

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; Integrated Security = True"

$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
$SqlAdapter.Fill($DataSet)

$SqlConnection.Close()

clear

$DataSet.Tables[0]
</source>

← Older revision		Revision as of 18:32, 27 August 2014
Line 47:		Line 47:
	}		}
	</source>		</source>
		+	http://blog.ittoby.com/2013/01/howto-connect-powershell-to-sql.html

@@ Line 29: / Line 29: @@
 <source lang="powershell">
 $SQLDBName = “somedb”
 $SqlQuery = ‘EXEC [dbo].[usp_mystoredprocedure] ”’ + $parameter1 + ”’, ”’ + $parameter2 + ””
 $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
 $SqlConnection.ConnectionString = “Server=$SQLServer;Database=$SQLDBName;Integrated Security=True”
 $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
 $SqlAdapter.Fill($DataSet)
 $SqlConnection.Close()
 foreach ($row in $DataSet.Tables[0].Rows)
-−
+{
-−
-−
 $Drive = $row[1].ToString().Trim()
 $Threshold = $row[2].ToString()
 $MountPoint = $row[3].ToString().Trim()
+}
 </source>

← Older revision		Revision as of 18:28, 27 August 2014
Line 23:		Line 23:

	$DataSet.Tables[0]		$DataSet.Tables[0]
		+	</source>
		+
		+	<source lang="powershell">
		+	$SQLDBName = “somedb”
		+
		+	$SqlQuery = ‘EXEC [dbo].[usp_mystoredprocedure] ”’ + $parameter1 + ”’, ”’ + $parameter2 + ””
		+
		+	$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
		+
		+	$SqlConnection.ConnectionString = “Server=$SQLServer;Database=$SQLDBName;Integrated Security=True”
		+
		+	$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
		+
		+	$SqlAdapter.Fill($DataSet)
		+
		+	$SqlConnection.Close()
		+
		+	foreach ($row in $DataSet.Tables[0].Rows)
		+
		+	{
		+
		+	$Drive = $row[1].ToString().Trim()
		+
		+	$Threshold = $row[2].ToString()
		+
		+	$MountPoint = $row[3].ToString().Trim()
		+
		+	}
	</source>		</source>

Querying Sql Server - Revision history

George2 at 18:32, 27 August 2014

George2 at 18:29, 27 August 2014

George2 at 18:28, 27 August 2014

George2 at 18:28, 27 August 2014

George2: Created page with "'''Some examples from Google''' $SQLDBName = "MyDBName" $SqlQuery = "select * from authors WHERE Name = 'John Simon'" $SqlConnection = Ne..."

George2: Created page with "'''Some examples from Google'''

$SQLDBName = "MyDBName" $SqlQuery = "select * from authors WHERE Name = 'John Simon'" $SqlConnection = Ne..."