If you’ve ever used the Template Explorer
Ctrl+Alt+T in SQL Server Management Studio (SSMS), then you may already be familiar with the concept of parameterized scripts in SSMS. You can use
Ctrl+Shift+M to replace parameterized values in the template with your own values. You can also create your own parameterized values in SQL scripts that you may have.
The parameters are enclosed in angle brackets and have three values like so.
<parameter_name, data_type, default_value>
Let’s say you wanted to create sandbox databases for various individuals to have their own copy.