Transact-SQL, Stored Procedure, and Query are the three main types of SQL. Transact-SQL is the main programming language for Microsoft SQL Server. Stored procedures are applications that are created in T-SQL and can be called from other applications. Finally, queries are used to pull data from a database and present it to end users.
Standard SQL
If you are new to SQL, you may have heard of three different types of SQL queries: SELECT, INSERT, and UPDATE. These queries are the most commonly used in SQL and are often the centre of any data analysis you do. If you are working with a relational database, you will use these types of queries to retrieve, update and insert data.
Extended SQL
SQL is a structured query language that allows you to define, execute and manage complex queries against relational databases. It is commonly used for data analysis and business intelligence. It has three main types:
Formatted SQL
SQL is a language that is used to communicate with a database. There are three different types of SQL: structured, unstructured, and scripting. A structured SQL query is one that returns results in a table or spreadsheet. Unstructured queries return results as a set of rows and columns.
Dynamic SQL
Depending on the language and the platform that you use, SQL is usually categorized into three types: Stored Procedures, Transact-SQL (T-SQL), and Query Language (or Query). These three types of SQL are often used interchangeably, but they have slight differences.
PL/SQL
There are three main types of SQL statements: SELECT, INSERT, and UPDATE. These statements are used to retrieve data from the database, insert new data, or update existing data, respectively. Other types of SQL queries are DDL queries, which create, alter, or drop objects in a database.
Stored procedures
There are three types of SQL statements: DML, DQL, and UDF. DML refers to Data Manipulation Language. This type of SQL can add, update, or delete data. DQL is Data Query Language. This type of SQL queries the database to retrieve data. UDF is User-defined Functions. These functions can be extremely powerful as they can be called from other SQL functions and may return data as well.
Triggers
There are three major types of SQL queries: SELECT, UPDATE, and DELETE. These are the most frequently used queries in databases and are referred to as CRUD (Create, Read, Update, Delete) operations.
Conclusion
The three most popular SQL dialects are Transact-SQL, which is the standard for Microsoft SQL Server, and MySQL and PostgreSQL. These are the most commonly used SQL dialects in the IT world. There are also a number of other dialects, such as Oracle SQL, which is used in Oracle Database.