MS SQL Basics Tutorial: A summary of Transact-SQL languages

Standard SQL statements are unobstructed in Transact-SQL languages. Transact-SQL also has a sort of classification similar to that of the language, but many extensions have been made. The classification of Transact-SQL languages is as follows:

• Variable Description

The command used to describe the variable.

• Data definition language (ddl,data definition Language)

Used to create databases, database objects, and define their columns, most of which are commands that start with create, such as Create TABLE, create VIEW, DROP table, and so on.

• Data Manipulation language (Dml,data manipulation Language)

Commands for manipulating data in a database, such as SELECT, INSERT, UPDATE, DELETE, cursor, and so on.

• Data Control Language (DCL, Language)

Commands to control access permission, access permissions, etc. of database components. such as Grant, REVOKE and so on.

• Process Control Language (flow controls Language)

Statements for designing an application such as if while case

• Inline function

The command that describes the variable.

• Other Orders

Standard functions to be used in commands

In the above classification languages, data definition language DDL, Data manipulation language DML, Data Control Language DCL distributed in later chapters, this chapter focuses on variable description, process control, inline functions, and other poorly categorized commands.

See the full set of "MS SQL Basics Tutorials"