SQL Server
Introduction SQL Query SQL Stored Procedures SQL Triggers SQL Joins
SQL Views   Indexes BCP (Bulk Copy Program) Table Commands SQL Operators

Sorry the information on this page is outdated as it relates to older versions of SQL Server.

We have new content and free videos at this location, http://www.learningcomputer.com/videotraining.html Please note that rest of the SQL Server videos can be bought from this page Buy Tutorials Please send any comments or suggestion to  kashi@learningcomputer.com

SQL Server is the Database Management System from Microsoft. It is a relational DBMS like Oracle, Sybase etc. Rather than discussing all the topics in detail, I will talk about the important issues and problems related to these issues. If you like a topic, you can go directly to it.

Important Transact SQL commands that are used frequently

  1. INSERT INTO

  2. DELETE..FROM

  3. SELECT..FROM

  4. UPDATE

  5. SELECT MAX ..FROM

  6. SELECT COUNT .. FROM

  7. SELECT DISTINCT..FROM

  8. SELECT..FROM..WHERE

  9. SELECT..FROM..ORDER by