RECEIVE retrieves one or more messages from a queue. Depending on the retention setting for the queue, either removes the message from the queue or updates the status of the message in the queue.

Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.

We can't use function to Insert, Update, Delete records in the database table(s).

Most of the Service broker statements cannot be included in the definition of a Transact-SQL user-defined function.

SQL Server is packed full of useful system stored procedures there for its own use that you can use as well.

SQL Server supports four types of cursor.

In SQL Server we can create triggers on DML statements (like INSERT, UPDATE, and DELETE) and stored procedures that perform DML-like operations.

Logon event is raised when a user session is being established with Sql Server that is made after the authentication phase finishes.

The output type @retType is passed as the second parameter to sp_executesql.

DML statements can be checked for handling errors.