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.
V0286:
The specification states the following:
-
Subclause 7.6, "<table reference>": <table reference> ::= <table factor> | <joined table> <table factor> ::= <table primary> [ <sample clause> ] <sample clause> ::= TABLESAMPLE <sample method> <left paren> <sample percentage> <right paren> [ <repeatable clause> ] ... Conformance Rules Without Feature T613, "Sampling", conforming SQL language shall not contain a <sample clause>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL partially supports this feature. The TABLESAMPLE clause does not support the BERNOULLI keyword, and the syntax of the clause differs slightly from the standard.