MSSQL The ANSI settings

Many of the connection-level options configure ANSI (American National Standards Institutes) compatibility or specific connection-performance options. To view current settings of connection-level options, query the sys.dm_exec_connections dynamic management view.
-SET ANSI_NULLS:
-SET CURSOR_CLOSE_ON_COMMIT:
-SET ANSI_NULL_DFLT_ON:
-SET IMPLICIT_TRANSACTIONS:
-SET ANSI_PADDING:
-SET QUOTED_IDENTIFIER:
-SET ANSI_WARNINGS:
Connection properties can also be checked by means of the SessionProperty() function: Select SESSIONPROPERTY (‘ANSI_NULLS’);

One thought on “MSSQL The ANSI settings

Leave a Reply

Your email address will not be published. Required fields are marked *