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:
Newer Posts Older Posts Home
Subscribe to: Posts (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.