SQL Server Management Studio tip: specifying values for template parameters in queries

SQL Server Management Studio is one of my daily tools, along with Visual Studio. SQL Server Management Studio (SSMS) contains many useful pre-built scripts in its Template Explorer window, and sometimes, these templated might contain parameters.

Here's the tip for today: if you want to quickly enter parameter values at once, use the command "Specify Values for Template Parameters" from the Query menu. This opens a new dialog box on the screen, similar to the way you'd enter parameter values for a stored procedure. This way, you don't need to write SQL code to enter the parameter values.

Hope this helps!