WrapperSQl Script

• satvindersingh78

  Newbie

  Points: 1

  More actions

  February 10, 2014 at 10:30 am

  #289340

  Hi friends,

  I am trying to create a wrapper script for the SQL. I am trying to create a batch file, so that all the sql can be run together and can be directed to a flat file.

  will appreciate light to it.

• Grant Fritchey

  SSC Guru

  Points: 399061

  More actions

  February 11, 2014 at 3:32 am

  #1687830

  You'll want to read up on the sqlcmd.exe utility. If you are looking to do things through the command line, it's one method. Another would be to use PowerShell. You can call that through the invoke-sqlcmd commandlet.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning