Wednesday, October 5, 2016

How to use SQL Server templates?

Unfortunately, many developers are unaware of available templates. SQL Server provides templates for almost all operations you can perform with relational databases and multidimensional databases, hence you do not need to remember all commands and the way code should be written.

For example, if you need to create a Linked Server object to an external database, you can simply take the template available and modify with values related.

You can find all templates using Template Explorer. Use either View -> Template Explorer menu or press Ctrl+Alt+T for viewing templates.

Expand the relevant node you look for and double click the template. The below image shows the template Add Linked Server Access MDB opened.

You can easily change values related by pressing Ctrl+Shift+M. It opens a window that you can use for setting values.

No comments: