Skip to content

Commit cba4a02

Browse files
committed
Tablesample doesn't work with DELETE
1 parent 416a3b2 commit cba4a02

1 file changed

Lines changed: 2 additions & 2 deletions

File tree

docs/t-sql/queries/from-transact-sql.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -232,7 +232,7 @@ FROM { <table_source> [ ,...n ] }
232232
### Tablesample clause
233233
**Applies to:** SQL Server, SQL Database
234234

235-
Specifies that a sample of data from the table is returned. The sample may be approximate. This clause can be used on any primary or joined table in a SELECT, UPDATE, or DELETE statement. TABLESAMPLE cannot be specified with views.
235+
Specifies that a sample of data from the table is returned. The sample may be approximate. This clause can be used on any primary or joined table in a SELECT or UPDATE statement. TABLESAMPLE cannot be specified with views.
236236

237237
> [!NOTE]
238238
> When you use TABLESAMPLE against databases that are upgraded to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], the compatibility level of the database is set to 110 or higher, PIVOT is not allowed in a recursive common table expression (CTE) query. For more information, see [ALTER DATABASE Compatibility Level &#40;Transact-SQL&#41;](../../t-sql/statements/alter-database-transact-sql-compatibility-level.md).
@@ -258,7 +258,7 @@ FROM { <table_source> [ ,...n ] }
258258
### Tablesample clause
259259
**Applies to:** SQL Data Warehouse
260260

261-
Specifies that a sample of data from the table is returned. The sample may be approximate. This clause can be used on any primary or joined table in a SELECT, UPDATE, or DELETE statement. TABLESAMPLE cannot be specified with views.
261+
Specifies that a sample of data from the table is returned. The sample may be approximate. This clause can be used on any primary or joined table in a SELECT or UPDATE statement. TABLESAMPLE cannot be specified with views.
262262

263263
PERCENT
264264
Specifies that a *sample_number* percent of the rows of the table should be retrieved from the table. When PERCENT is specified, SQL Data Warehouse returns an approximate of the percent specified. When PERCENT is specified, the *sample_number* expression must evaluate to a value from 0 to 100.

0 commit comments

Comments
 (0)