SqlDependency support for Select

https://msdn.microsoft.com/library/ms181122.aspxsupported SELECT Statements

Query notifications are supported for SELECT statements that meet the following requirements:

• The columns extracted in the SELECT statement must be explicitly described, and the table name must be limited to a two-part name. Note that this means that all the tables referenced in the statement must be in the same database.

• A statement cannot specify a column using the asterisk (*) or table_name.* syntax.

• The statement cannot use unnamed columns or duplicate column names.

• Statement must reference the base table.

• Statement cannot refer to a table with computed columns.

• The column extracted in the SELECT statement cannot contain an aggregate expression unless the statement uses a GROUP by expression. When you provide a GROUP by expression, the selection list can contain an aggregate function count_big () or SUM (). However, you cannot specify SUM () for nullable columns. Statement cannot specify having, CUBE, or ROLLUP.

• Columns that are extracted in a SELECT statement as a simple expression cannot be displayed more than once.

• A statement cannot contain a PIVOT or UNPIVOT operator.

• A statement cannot contain a UNION, INTERSECT, or EXCEPT operator.

• Statement cannot reference a view.

• A statement cannot contain any of the following: DISTINCT, COMPUTE, COMPUTE by, or into.

• A statement cannot reference a server global variable(@@ variable_name).

• A statement cannot reference a derived table, temporary table, or table variable.

• Statement cannot reference a table or view from another database or server.

• A statement cannot contain a subquery, an outer join, or a self-join.

• Statements cannot reference the following large object types:text,ntext, and image.

• Statement cannot use CONTAINS or FREETEXT full-text predicates.

• Statements cannot use rowset functions, including OPENROWSET and OPENQUERY.

• Statement cannot use any of the following aggregate functions: AVG, COUNT (*), MAX, MIN, STDEV, STDEVP, VAR, or VARP.

• The statement cannot use any of the nondeterministic functions, including the Rank function and the window-opening function.

• Statement cannot contain user-defined aggregations.

• Statements cannot reference system tables or views, including catalog views and dynamic management views.

• The statement cannot contain the for BROWSE information.

• Statement cannot reference a queue.

• Statements cannot contain conditional statements (such as WHERE 1=0) that cannot be changed and cannot be returned.

• Statement cannot specify a READPAST lock hint.

• Statement cannot reference any Service Broker QUEUE.

• A statement cannot reference a synonym.

• A statement cannot have a comparison or an expression based on an Double/real data type.

• Statement must not use the TOP expression.

SqlDependency support for Select