Skip to content

Commit 856fda7

Browse files
ShannonLeavittShannonLeavitt
authored
Merge pull request #16993 from Kat-Campise/tsql_renaming3
tsql renaming set 3
2 parents 6385766 + d423c36 commit 856fda7

12 files changed

Lines changed: 28 additions & 28 deletions

‎docs/t-sql/queries/aliasing-azure-sql-data-warehouse-parallel-data-warehouse.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "Aliasing"
3-
description: "Aliasing in Azure SQL Data Warehouse and Parallel Data Warehouse."
4-
titleSuffix: Azure SQL Data Warehouse
3+
description: "Aliasing in Azure Synapse Analytics and Parallel Data Warehouse."
4+
titleSuffix: Azure Synapse Analytics
55
ms.custom: "seo-lt-2019"
66
ms.date: "03/16/2017"
77
ms.prod: sql
@@ -14,7 +14,7 @@ ms.author: shkale
1414
monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions"
1515
---
1616

17-
# Aliasing (Azure SQL Data Warehouse, Parallel Data Warehouse)
17+
# Aliasing (Azure Synapse Analytics, Parallel Data Warehouse)
1818

1919
[!INCLUDE[applies-to-version/asa-pdw](../../includes/applies-to-version/asa-pdw.md)]
2020

‎docs/t-sql/queries/explain-transact-sql.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -16,7 +16,7 @@ monikerRange: "= azure-sqldw-latest || = sqlallproducts-allversions"
1616

1717
[!INCLUDE [asa](../../includes/applies-to-version/asa.md)]
1818

19-
Returns the query plan for a [!INCLUDE[ssDW](../../includes/ssdw-md.md)] [!INCLUDE[DWsql](../../includes/dwsql-md.md)] statement without running the statement. Use EXPLAIN to preview which operations will require data movement and to view the estimated costs of the query operations. `WITH RECOMMENDATIONS` applies to Azure SQL Data Warehouse.
19+
Returns the query plan for a [!INCLUDE[ssDW](../../includes/ssdw-md.md)] [!INCLUDE[DWsql](../../includes/dwsql-md.md)] statement without running the statement. Use EXPLAIN to preview which operations will require data movement and to view the estimated costs of the query operations. `WITH RECOMMENDATIONS` applies to [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)].
2020

2121
## Syntax
2222

@@ -37,7 +37,7 @@ Return the query plan with recommendations to optimize the SQL statement perform
3737

3838
## Permissions
3939

40-
Requires the **SHOWPLAN** permission, and permission to execute *SQL_statement*. See [Permissions: GRANT, DENY, REVOKE (Azure SQL Data Warehouse, Parallel Data Warehouse)](../../t-sql/statements/permissions-grant-deny-revoke-azure-sql-data-warehouse-parallel-data-warehouse.md).
40+
Requires the **SHOWPLAN** permission, and permission to execute *SQL_statement*. See [Permissions: GRANT, DENY, REVOKE (Azure Synapse Analytics, Parallel Data Warehouse)](../../t-sql/statements/permissions-grant-deny-revoke-azure-sql-data-warehouse-parallel-data-warehouse.md).
4141

4242
## Return Value
4343

@@ -615,6 +615,6 @@ FROM (SELECT CONVERT (INT, [T2_1].[col], 0) AS [col]
615615
[sys.pdw_materialized_view_distribution_properties (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-pdw-materialized-view-distribution-properties-transact-sql?view=azure-sqldw-latest)
616616
[sys.pdw_materialized_view_mappings (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-pdw-materialized-view-mappings-transact-sql?view=azure-sqldw-latest)
617617
[DBCC PDW_SHOWMATERIALIZEDVIEWOVERHEAD (Transact-SQL)](/sql/t-sql/database-console-commands/dbcc-pdw-showmaterializedviewoverhead-transact-sql?view=azure-sqldw-latest)
618-
[SQL Data Warehouse and Parallel Data Warehouse Catalog Views](../../relational-databases/system-catalog-views/sql-data-warehouse-and-parallel-data-warehouse-catalog-views.md)
619-
[System views supported in Azure SQL Data Warehouse](/azure/sql-data-warehouse/sql-data-warehouse-reference-tsql-system-views)
620-
[T-SQL statements supported in Azure SQL Data Warehouse](/azure/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements)
618+
[Azure Synapse Analytics and Parallel Data Warehouse Catalog Views](../../relational-databases/system-catalog-views/sql-data-warehouse-and-parallel-data-warehouse-catalog-views.md)
619+
[System views supported in Azure Synapse Analytics](/azure/sql-data-warehouse/sql-data-warehouse-reference-tsql-system-views)
620+
[T-SQL statements supported in Azure Synapse Analytics](/azure/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements)

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

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -132,7 +132,7 @@ This article also discusses the following keywords that can be used on the FROM
132132
```
133133

134134
```syntaxsql
135-
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
135+
-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
136136
137137
FROM { <table_source> [ ,...n ] }
138138
@@ -145,7 +145,7 @@ FROM { <table_source> [ ,...n ] }
145145
}
146146
147147
<tablesample_clause> ::=
148-
TABLESAMPLE ( sample_number [ PERCENT ] ) -- SQL Data Warehouse only
148+
TABLESAMPLE ( sample_number [ PERCENT ] ) -- Azure Synapse Analytics only
149149
150150
<joined_table> ::=
151151
{
@@ -264,12 +264,12 @@ FROM { <table_source> [ ,...n ] }
264264
Is a constant integer expression used by [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] to generate a random number. *repeat_seed* is **bigint**. If *repeat_seed* is not specified, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] assigns a value at random. For a specific *repeat_seed* value, the sampling result is always the same if no changes have been applied to the table. The *repeat_seed* expression must evaluate to an integer greater than zero.
265265

266266
### Tablesample clause
267-
**Applies to:** SQL Data Warehouse
267+
**Applies to:** [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)]
268268

269269
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.
270270

271271
PERCENT
272-
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.
272+
Specifies that a *sample_number* percent of the rows of the table should be retrieved from the table. When PERCENT is specified, [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] returns an approximate of the percent specified. When PERCENT is specified, the *sample_number* expression must evaluate to a value from 0 to 100.
273273

274274

275275
### Joined table

‎docs/t-sql/queries/option-clause-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -41,7 +41,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
4141
```
4242

4343
```syntaxsql
44-
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
44+
-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
4545
4646
OPTION ( <query_option> [ ,...n ] )
4747

‎docs/t-sql/queries/queries.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
1919

2020
[!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
2121

22-
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] and SQL Database. Most also work in SQL Data Warehouse and PDW (review each individual statement for details). Use these statements to add, modify, query, or remove data from a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database.
22+
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] and SQL Database. Most also work in [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] (review each individual statement for details). Use these statements to add, modify, query, or remove data from a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database.
2323

2424
## In This Section
2525
The following table lists the DML statements that [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] uses.

‎docs/t-sql/queries/search-condition-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -89,7 +89,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
8989
```
9090

9191
```syntaxsql
92-
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
92+
-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
9393
9494
< search_condition > ::=
9595
{ [ NOT ] <predicate> | ( <search_condition> ) }

‎docs/t-sql/queries/select-group-by-transact-sql.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -80,7 +80,7 @@ GROUP BY
8080
```
8181

8282
```syntaxsql
83-
-- Syntax for Azure SQL Data Warehouse
83+
-- Syntax for Azure Synapse Analytics
8484
8585
GROUP BY {
8686
column-name [ WITH (DISTRIBUTED_AGG) ]
@@ -282,11 +282,11 @@ GROUP BY ALL:
282282
- Will fail on columns that have the FILESTREAM attribute.
283283

284284
### WITH (DISTRIBUTED_AGG)
285-
Applies to: Azure SQL Data Warehouse and Parallel Data Warehouse
285+
Applies to: [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]
286286

287287
The DISTRIBUTED_AGG query hint forces the massively parallel processing (MPP) system to redistribute a table on a specific column before performing an aggregation. Only one column in the GROUP BY clause can have a DISTRIBUTED_AGG query hint. After the query finishes, the redistributed table is dropped. The original table is not changed.
288288

289-
NOTE: The DISTRIBUTED_AGG query hint is provided for backwards compatibility with earlier Parallel Data Warehouse versions and will not improve performance for most queries. By default, MPP already redistributes data as necessary to improve performance for aggregations.
289+
NOTE: The DISTRIBUTED_AGG query hint is provided for backwards compatibility with earlier [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] versions and will not improve performance for most queries. By default, MPP already redistributes data as necessary to improve performance for aggregations.
290290

291291
## General Remarks
292292

@@ -309,7 +309,7 @@ NULL values:
309309

310310
## Limitations and Restrictions
311311

312-
Applies to: SQL Server (starting with 2008) and Azure SQL Data Warehouse
312+
Applies to: SQL Server (starting with 2008) and [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)]
313313

314314
### Maximum capacity
315315

@@ -410,7 +410,7 @@ HAVING DATEPART(yyyy,OrderDate) >= N'2003'
410410
ORDER BY DATEPART(yyyy,OrderDate);
411411
```
412412

413-
## Examples: SQL Data Warehouse and Parallel Data Warehouse
413+
## Examples: Azure Synapse Analytics and Parallel Data Warehouse
414414

415415
### E. Basic use of the GROUP BY clause
416416
The following example finds the total amount for all sales on each day. One row containing the sum of all sales is returned for each day.

‎docs/t-sql/queries/select-order-by-clause-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -77,7 +77,7 @@ ORDER BY order_by_expression
7777
```
7878

7979
```syntaxsql
80-
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
80+
-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
8181
8282
[ ORDER BY
8383
{

‎docs/t-sql/queries/select-over-clause-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -44,7 +44,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
4444
## Syntax
4545

4646
```syntaxsql
47-
-- Syntax for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse
47+
-- Syntax for SQL Server, Azure SQL Database, and Azure Synapse Analytics
4848
4949
OVER (
5050
[ <PARTITION BY clause> ]

‎docs/t-sql/queries/select-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,7 @@ SELECT [ ALL | DISTINCT ]
7676
```
7777

7878
```syntaxsql
79-
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
79+
-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
8080
8181
[ WITH <common_table_expression> [ ,...n ] ]
8282
SELECT <select_criteria>

0 commit comments

Comments
 (0)