My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQLCMD pointers
The new RSS feed is here
Following on from my previous post if using SQLCMD. you need to be aware of the following
- You can comment out sqlcmd statements in the usual way
- files paths are relative to your default folder on the machine you are running the script, i.e. your workstation for me this is c:\documents and settings\simonsa
- if a value contains a space use quotes i.e :setvar progdir "c:\program files"
- if using a variable and some other text with a space do not include the variable in the quoted part i.e.
- use this :r $(progdir)"\Microsoft SQL Server\some file.sql"
- not this :r "$(progdir)\Microsoft SQL Server\some file.sql"
Thats all for now.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLCMD pointers