Differences Between SQL and T-SQL

SQL VS T-SQL

Microsoft added new features always to improve the quality of software so Microsoft add codes to SQl called T-SQL. It means T-SQL is under control in to Microsoft and proprietary.

T-SQL have many features which are not available in SQL server such as procedural programming element and local variables, which is helpful in flexible control.

t-SQL have mathematics operation function, string operation function, time and date processor etc. and due to this t-SQl can compile with Turing completeness test, this test explain universality of programming, where as this is absent in SQL.

In T-SQL UPDATE and DELETE command comes with inclusion of FROM clause that is allow to JOINs where as in SQL this is absent.

We can say that T-SQL is extension of language where as SQL is programming language.

T-SQL perform wel when you use Microsoft.

To submit Advanced SQL assignment click here

• ← Previous Features of SQL Advance