SQL Server/T-SQL Tutorial/System Settings/SESSIONPROPERTY

Материал из SQL эксперт
Перейти к: навигация, поиск

SELECT SESSIONPROPERTY ("ANSI_PADDING") ANSI_PADDING

   <source lang="sql">

3> 4> SELECT SESSIONPROPERTY ("ANSI_PADDING") ANSI_PADDING 5> GO ANSI_PADDING

















1

















(1 rows affected)</source>


SELECT SESSIONPROPERTY ("ANSI_WARNINGS") ANSI_WARNINGS

   <source lang="sql">

3> 4> SELECT SESSIONPROPERTY ("ANSI_WARNINGS") ANSI_WARNINGS 5> GO ANSI_WARNINGS

















1

















(1 rows affected)</source>


SELECT SESSIONPROPERTY ("ARITHABORT") ARITHABORT

   <source lang="sql">

3> 4> SELECT SESSIONPROPERTY ("ARITHABORT") ARITHABORT 5> GO ARITHABORT

















0

















(1 rows affected)</source>


SELECT SESSIONPROPERTY ("CONCAT_NULL_YIELDS_NULL") CONCAT_NULL_YIELDS_NULL

   <source lang="sql">

3> 4> SELECT SESSIONPROPERTY ("CONCAT_NULL_YIELDS_NULL") CONCAT_NULL_YIELDS_NULL 5> GO CONCAT_NULL_YIELDS_NULL

















1

















(1 rows affected)</source>


SELECT SESSIONPROPERTY ("NUMERIC_ROUNDABORT") NUMERIC_ROUNDABO

   <source lang="sql">

3> 4> 5> SELECT SESSIONPROPERTY ("NUMERIC_ROUNDABORT") NUMERIC_ROUNDABO 6> GO NUMERIC_ROUNDABO

















0

















(1 rows affected)</source>


SELECT SESSIONPROPERTY ("QUOTED_IDENTIFIER") QUOTED_IDENTIFIER

   <source lang="sql">

3> 4> SELECT SESSIONPROPERTY ("QUOTED_IDENTIFIER") QUOTED_IDENTIFIER 5> GO QUOTED_IDENTIFIER

















0

















(1 rows affected)</source>


Viewing User Connection Options

   <source lang="sql">

4> 5> SELECT SESSIONPROPERTY ("ANSI_NULLS") ANSI_NULLS 6> GO ANSI_NULLS

















1

















(1 rows affected)</source>

Источник — «http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/SESSIONPROPERTY&oldid=6619»