SQL

Hi,

As promised earlier, this is my first post containing link and things learnt/noticed today:

While searching for SQL help, i came across this link: http://www.w3schools.com/sql. This seems to be a nice place to start coz it has very less of mumbo jumbo with a simplistic approach.
You will find tutorials about other technologies as well.

Noticed a few interesting things in Query Analyzer:

1. Under Common Objects subtree, all sorts of utility function such as datetime, configuration, math, Security function are listed with their arguments. If in doubt this could be refered anytime.

2. The other thing is that the Template tab contains templates for almost all the things done in SQL. Templates for database creation, triggers, statistics and cursors along with others could be used as Verbatim.