OUTPUT Clause

Returns inserted, updated, or deleted rows to the calling application as part of the INSERT, UPDATE, or DELETE statement.

WITH common_table_expression

Specifies a temporary named result set or view defined within the scope of a SELECT, INSERT, UPDATE, or DELETE statement.

.WRITE Clause

Enables partial updates and high performance appends to varchar(max), nvarchar(max), and varbinary(max) data type columns as part of the UPDATE statement.

SELECT

Provides the following new syntax items:

• WITH common table expression
  
• TOP expression
  
• User-defined type column name for selecting a user-defined type value
  

INSERT

Provides the following new syntax items:

• WITH common table expression
  
• TOP expression
  
• OUTPUT clause
  

Allows for the insertion of user-defined type values.

UPDATE

Provides the following new syntax items:

• WITH common table expression
  
• TOP expression
  
• OUTPUT clause
  
• User-defined type column name for updating a user-defined type value
  
• .WRITE clause
  

DELETE

Provides the following new syntax items:

• WITH common table expression
  
• TOP expression
  
• OUTPUT clause
  

FOR Clause

Provides the following new FOR XML directives:

• TYPE enables the retrieval of query results as an xml type.
  
• XMLSCHEMA enables requests of an XSD schema.
  

Allows for nested FOR XML queries.

FROM

Provides the following additional table-source syntax:

• APPLY
  
• PIVOT/UNPIVOT
  
• TABLESAMPLE
  
• Bulk column alias
  

TOP

Can be used with SELECT, INSERT, UPDATE, and DELETE statements.

BEGIN DIALOG

Starts a new conversation between two services.

BEGIN CONVERSATION TIMER

Starts a timer on a conversation.

END CONVERSATION

Ends an existing conversation.

GET CONVERSATION GROUP

Locks the conversation group for the next available message on a queue.

MOVE CONVERSATION

Associates an existing conversation with a different conversation group.

RECEIVE

Retrieves one or more messages from a queue.

SEND

Sends a message to a service.