Session settings

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 determine which users and logins can access data and perform

operations. For more information about authentication and access, see the

Security center.

Service Broker is a feature that provides native support for messaging and queuing

applications. For more information, see

Service Broker.

SET statements determine how the current session handles run time settings. For an overview,

see

SET statements.