Please note that the information on this page is related to an older version of Microsoft SQL Server.

Click on SQL Server Tutorials for new training content and material. In addition we have FREE SQL Tutorial videos here, so feel free to download the demos. Our partners also manage two blogs on the following SQL Server Versions:

-SQL Server 2008 Blog
-SQL Azure Blog

Please send any comments or suggestion to info@sqlserver2008tutorial.com

SQL Server is the Database Management System from Microsoft. It is a relational DBMicrosoft 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