Dynamic Sql Assign Value To Variable

The capability to edit and execute sqlcmdscripts was added to SSMS with SQL Server 2005. A sqlcmdscript can be opened or created in a Query Editor window within SSMS. To edit these scripts, you must place the editor in SQLCMD Mode. You do so by selecting Query, SQLCMD Mode or by clicking the related toolbar button. When the editor is put in ................
................