YogB's Technology Blog

ASP.NET, C#.NET, CruiseControl.NET, Microsoft SQL Server, MS-DOS Batch, MySQL, nAnt, NodeJs, PowerShell, Python, Selenium RC, Redis, WebAii, Ubuntu

Tuesday, February 09, 2016

Execute MS SQL commands from PowerShell

In order to execute MS SQL commands from PowerShell I used following script.

$sqlquery=@"
USE [DBName]
GO
select * from table
"@

Invoke-Sqlcmd -ServerInstance "ServerName" -Query $sqlquery -Verbose
Posted by Yogesh at 2/09/2016 02:44:00 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2021 (1)
    • ►  July (1)
  • ▼  2016 (9)
    • ►  November (2)
    • ►  June (5)
    • ►  March (1)
    • ▼  February (1)
      • Execute MS SQL commands from PowerShell
  • ►  2015 (4)
    • ►  October (1)
    • ►  September (2)
    • ►  July (1)
  • ►  2014 (7)
    • ►  March (1)
    • ►  February (6)
  • ►  2013 (3)
    • ►  December (1)
    • ►  November (1)
    • ►  August (1)
  • ►  2012 (4)
    • ►  December (2)
    • ►  May (2)
  • ►  2011 (12)
    • ►  October (1)
    • ►  July (2)
    • ►  June (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (3)
  • ►  2010 (21)
    • ►  December (1)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  March (4)
    • ►  February (5)
    • ►  January (6)
  • ►  2009 (18)
    • ►  September (4)
    • ►  August (1)
    • ►  July (2)
    • ►  June (2)
    • ►  May (3)
    • ►  March (1)
    • ►  January (5)
  • ►  2008 (34)
    • ►  November (3)
    • ►  September (1)
    • ►  August (9)
    • ►  July (1)
    • ►  June (2)
    • ►  May (3)
    • ►  April (1)
    • ►  March (11)
    • ►  February (3)

About Me

Yogesh
View my complete profile
Simple theme. Powered by Blogger.