Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - What Is Transact-SQL Language

By: FYIcenter.com

(Continued from previous topic...)

What Is Transact-SQL Language?

According to Wikipedia, Transact-SQL, sometimes abbreviated T-SQL, is Microsoft's and Sybase's proprietary extension to the SQL language. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in its Adaptive Server Enterprise, the successor to Sybase SQL Server.

In order to make it more powerful, SQL has been enhanced with additional features such as:

  • Control-of-flow language - Like BEGIN and END, BREAK, CONTINUE, GOTO, IF and ELSE, RETURN, WAITFOR, and WHILE statements.
  • Local variables - Like DECLARE and SET statements
  • Various support functions for string processing, date processing, mathematics, etc. - Like SIN(), ASIN(), LOG(), etc.
  • Improvements to DELETE and UPDATE statements - Both the DELETE and UPDATE statements allow a FROM clause to be added which allows joins to be included.

(Continued on next topic...)

  1. What Is SQL Language?
  2. What Is Transact-SQL Language?
  3. What Is a Transact-SQL Statement?
  4. How To Start and End Transact-SQL Statements?
  5. How To Enter Comments in Transact-SQL Statements?
  6. What Is a Transact-SQL Statement Batch?
  7. What Happens to a Statement Batch If There Is a Compilation Error?
  8. How To Use GO Command in "sqlcmd"?
  9. How To Create User Messages with PRINT Statements?
  10. How Many Categories of Data Types Used by SQL Server?
  11. What Are Exact Numeric Data Types?
  12. What Are Approximate Numeric Data Types?
  13. What Are Date and Time Data Types?
  14. What Are Character String Data Types?
  15. What Are Unicode Character String Data Types?
  16. What Are Binary String Data Types?
  17. What Are the Differences between CHAR and NCHAR?
  18. What Are the Differences between CHAR and VARCHAR?
  19. What Are the Differences between DECIMAL and FLOAT?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: