What are the differences and similarities of SQL over T-SQL

SQL is a relational database management system. According to ANSI, it is the standard language for relational database management systems. Using SQL one does communicate to the database.

 

On the other hand,  T-SQL (Transact-SQL) is a set of programming extensions which any RDBMS package following ANSI standard uses. It offers many features such as Structured Query Language (SQL), Procedure, Trigger, exception, error handling and declaring variables.

Hi Harish,  

By using SQL we can write the DDL statements as well as DML statements or joins and more single statement wise queried.

By using TSQL we can write procedures,views,functions,triggers. These are called as TSQL objects.

T-sql are basically used to write some extent of business logics or can perform the calculationsand pass the data to the requested one.

Mark as answer if you understood. If not comeup with your query.

Thank you.