Pass parameters in SQLCMD

• saqlainkhan

  Ten Centuries

  Points: 1126

  More actions

  January 21, 2010 at 11:31 am

  #219737

  is it possible to pass parameters into sqlcmd. For instance user A wants to pass inthe location of the folder where his files are stored and in turn replace the location in the command below

  the sqlcmd that is used is as following:

  :r "\\user\c$\folder\xyz.sql"

  Noli Timere

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  January 22, 2010 at 8:06 am

  #1107362

  Yes, you can use variables with sqlcmd, see Books Online (http://msdn.microsoft.com/en-us/library/ms188714.aspx) for more details.

  E.g.:

  In your script change the definition to:

  :r $(scriptfile)

  Assign the variable at execution:

  sqlcmd.exe -v scriptfile="\\user\c$\folder\xyz.sql"

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com