Search this blog

Monday, April 9, 2012

Difference Between SQL Vs. T-SQL?

SQL and T-SQL are Query languages, both helps to extract, Manipulate data with database system.

SQL – Structured Query Language:-

It is pronounced as SEQUEL, stands for… Structured English QUEry Languages. 
  • SQL Language has several language elements called clauses, phrases, predicates, queries and statements. 
  • SQL Supports  to insert/update/read/delete the data from/to the database, define the new structure, etc., 
  • SQL supports different data types like image, text, varchar, datetime,xml, etc., SQL supports only single line transactions

T-SQL – Transact-SQL:-

T-SQL is advanced/addition to the SQL developed by Microsoft. It has new features like, variable, temp tables, set of transactions, store procedures, functions, cursors etc.., T-SQL supports control flow capabilities by using the following commands: START and TERMINATE, break, CONTINUE, GOTO, RETURN, IF, While and WAITFOR. T-SQL allows the ‘FROM’ clause to be added to DELETE and UPDATE statements. T-SQL allows inserting multiple rows using single statement BULK INSERT.