Share via


2.1.2.250 T613, Sampling

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.