:::: MENU ::::

SET Options for a T-SQL query

  • Jan 07 / 2010
  • 0
dbDigger, T-SQL Interview Questions

SET Options for a T-SQL query

Question:

In creating a query that will be used in Query Notification, how are the SET options determined for the query?

Answer: A specific group of SET options are required on the client.

Explanation: When building a query for query notification, a specific set of SET option setttings must be on the client’s connection. specifically they are:

  • ANSI_NULLS ON
  • ANSI_PADDING ON
  • ANSI_WARNINGS ON
  • CONCAT_NULL_YIELDS_NULL ON
  • QUOTED_IDENTIFIER ON
  • NUMERIC_ROUNDABORT OFF
  • ARITHABORT ON

Note:: The question of day is taken from SqlServerCentral.com. I want to compile selected QOD to share.

Consult us to explore the Databases. Contact us