set statement can be used to assign a value to a variable or to set/unset a boolean-like option that changes how a session handles different things. The options that are altered with set affect the current session only. @@options variable. ansi_nulls set language sets the session language. set nocount on turns off messages like 42 row(s) affected: set nocount on; update tab_one set col_1 = 'xyz' where col_2 < 'abc';
set count off is not easily possible because count is already an SQL keyword. set noexec on|off controls if the following T-SQL statements are executed or parsed only. quoted_identifier sp_configure procedure.