Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0233:
The specification states the following:
-
Subclause 11.3, "<table definition>": <as subquery clause> ::= [ <left paren> <column name list> <right paren> ] AS <table subquery> <with or without data> <with or without data> ::= WITH NO DATA | WITH DATA ... Conformance Rules Without Feature T172, "AS subquery clause in table definition", conforming SQL language shall not contain an <as subquery clause>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.