Did anybody use sqlcmd mode in practice? SQLServer 2005 introduced something called  SQLCMD Mode msdn link.

At first glance this mode adds variable subsitution from command line batch files,  and some escaping to OS commands. 

Is this feature used in your environments, production or test?
I use the sqlcmd mode in SSMS on occasion. Typically when migrating databases from one environment to another.  For example if I need to backup the database from production, then restore it to dev, I'll do this all in one script using SQLCMD mode to switch servers.  I've used to here and there for one thing or another, but I don't use it all that often.