SET Statements - TSQL Tutorial

On Transact sql language the SET statements allow you to change the current session handling of specific information like: dateformat, system language, lock timeout, rowcount.

Date and time

Locks

Miscellaneous

Query Execution