Sunday, October 17, 2010

Template Explorer in SQL Server 2008

I know, most of us do not know what it is... But, there are nice advantages of it and everyone should know about it. Template Explorer contains so many templates which helps us to understand many things and these templates have many examples on how we can write or do things through SQL queries. There are lot of default templates available like Backup, Restore, Database Mail, Trigger, user, login etc...

To view the Template Explorer, follow the steps below.
  1. Open Sql Server.
  2. From "View" menu, select "Template Explorer".
This opens up the template explorer and there are lot of folders which helps you to understand and do some magic. To give the template parameters, no need to go to the sql code and edit. You can directly change them in the editor as described below.
  1. Open some template.
  2. Now, click on Query menu and select "Specify Values for Template Parameters".
  3. It will show you a windows with all parameters the template is looking for for the selected template.
That's it!!! This helped me to understand many things. Hope this helps to you too..

No comments:

Post a Comment