PowerShell
PowerShell copied to clipboard
[Question] - Variables
SqlCmd
allows you to pass variable values that can be used in scripts:
& sqlcmd -i CreateDb.sql -v dbName="foo"
CreateDb.sql
:
CREATE DATABASE $(dbName)
ON (
NAME = $(dbName)
)
LOG ON (
NAME = $(dbName)_log,
)
These are different from SQL parameters.
Does Invoke-SqlCmd2
cater for this functionality somehow?
Thanks