Guide for Sintaks for beginners, here's:
1. IN
2. BETWEEN
3. ALIAS for Table
4. AS for column
5. NULL
6. ISNULL()
7. COALESCE()
8. SET NOCOUNT
For check the capture step by step, please follow the free download link below :
SQL Server 2000 - Guide for Sintaks (5)