In TSQL, SET statement allows you to change the current session handling of specific information like: system language, dateformat, lock timeout, rowcount and so on.