A SQL statement is a set of instruction that consists of identifiers, parameters, variables, names, data types, and SQL reserved words that compiles successfully. Analysis Services creates an implicit transaction for a SQL statement if a Begin Transaction command does not specify the start of a transaction.
There are many types of statements. Perhaps the most important is the SELECT that retrieves rows from the database and enables the selection of one or many rows or columns from one or many tables in SQL Server. This article summarizes the categories of statements for use with Transact-SQL (T-SQL) in addition to the SELECT statement. You can find all of the statements listed in the left-hand navigation.
Data Definition Language
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
- ALTER
- Collations
- CREATE
- DROP
- DISABLE TRIGGER
- ENABLE TRIGGER
- RENAME
- UPDATE STATISTICS
- TRUNCATE TABLE
Data Manipulation Language
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
- BULK INSERT
- DELETE
- INSERT
- SELECT
- UPDATE
- MERGE
Permissions statements
Permissions statements determine which users and logins can access data and perform operations. For more information about authentication and access, see the Security center.
0 Comments