In my last article, I roughly described how standard SQL differs from T-SQL and who should learn which. Now I’d like to focus on the syntax differences and illustrate these differences with examples. If you think T-SQL is an extension implementing all the features from standard SQL, you aren’t right. However, in SQL Server you will find almost all the features of the SQL standard. In this article you will find examples of some of the differences in syntax between standard SQL and Transact-SQL.
If you are beginning to learn SQL and are confused by the differences between SQL and other similar languages like T-SQL, this article will help make things clear. You will also find explanations concerning which topics would be better to start learning first: general SQL or something more specific like MS SQL Server. What is SQL? SQL (Structured Query Language) is a basic ANSI/ISO standard programming language designed to operate on data stored in relational databases.