SQL Vs TSQL

SQL is a standard language for managing relational databases, while T-SQL is Microsoft's extension for SQL Server, adding procedural capabilities like stored procedures and triggers, and enhancing database functionality and control.

SQL

SQL was initially developed by IBM and later ANSI, or the American National Standards Institute, which made it standard. 'SQL' stands for Structured Query Language.

SQL is an open-source standard is a Non-procedural language type which means, SQL statements are executed one at a time.

SQL (Structured Query Language) is a standard language for querying and modifying data in the database. SQL allows you to define, select, modify data. It is used across many different types of databases. It is used for manipulating data when a large amount of information is stored.

DDL, and DML commands that used for communicating with databases like storing, retrieving, and manipulating data.

T-SQL

T-SQL is known as Transact Structured Query Language, which is the product of Microsoft. The purpose of T-SQL is used to provide a set of tools for the development of a transactional database.TSQL is an extension of the SQL language. It is mainly used for creating applications.

T-SQL is a proprietary standard. T-SQL is a procedural language of SQL, which means code will be executed as a block logically and structured order.

T-SQL contains procedural programming and local variables. In T-SQL there is a block that is used to write functions and procedures, there is no interaction with the database.