Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (eMicrosoft Partne)
  • When: 24 Mar 2012 2:20 PM
  • Last revision by (eMicrosoft Partne)
  • When: 10 Jul 2013 11:27 AM
  • Revisions: 4
  • Comments: 2
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: Get Data from SQL Server with PowerShell

SharePoint 2010: Get Data from SQL Server with PowerShell

SharePoint 2010: Get Data from SQL Server with PowerShell

A little script for getting data from SQL Server with PowerShell in SharePoint 2010:

 

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server=SQLServer\SQLInstance;Database=DataBaseName;Integrated Security=True"
$SqlConnection.Open()
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "select * from tblMARQUET"
$SqlCmd.Connection = $SqlConnection
$dbname = $SqlCmd.ExecuteScalar()
$SqlConnection.Close()
Write-output "Database is " $dbname

PS: do not forget to change your connectionstring and commandtext

, , , , , , , [Edit tags]
Leave a Comment
  • Please add 2 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 10 Jul 2013 11:27 AM

    Gokan Ozcifci edited Revision 2. Comment: Add Content

  • 8 Jul 2013 5:22 PM

    Ed Price - MSFT edited Original. Comment: Title; tags

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 8 Jul 2013 5:22 PM

    Ed Price - MSFT edited Original. Comment: Title; tags

  • Posted by
    on 10 Jul 2013 11:27 AM

    Gokan Ozcifci edited Revision 2. Comment: Add Content

Page 1 of 1 (2 items)