Skip to content

Commit ce9eaaa

Browse files
tfosmarktfosmark
authored
Merge pull request MicrosoftDocs#1469 from nschonni/typo-docs-t-sql
typo: Cleanup docs/t-sql
2 parents df4de21 + df13f19 commit ce9eaaa

66 files changed

Lines changed: 135 additions & 135 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/t-sql/data-types/date-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -60,7 +60,7 @@ The following tables show the valid string literal formats for the **date** data
6060
|------------------|-----------------|
6161
|mon [dd][,] yyyy<br /><br /> mon dd[,] [yy]yy<br /><br /> mon yyyy [dd]<br /><br /> [dd] mon[,] yyyy<br /><br /> dd mon[,][yy]yy<br /><br /> dd [yy]yy mon<br /><br /> [dd] yyyy mon<br /><br /> yyyy mon [dd]<br /><br /> yyyy [dd] mon|**mon** represents the full month name or the month abbreviation given in the current language. Commas are optional and capitalization is ignored.<br /><br /> To avoid ambiguity, use four-digit years.<br /><br /> If the day is missing, the first day of the month is supplied.|
6262

63-
|ISO 8601|Descripton|
63+
|ISO 8601|Description|
6464
|--------------|----------------|
6565
|YYYY-MM-DD<br /><br /> YYYYMMDD|Same as the SQL standard. This is the only format that is defined as an international standard.|
6666

‎docs/t-sql/data-types/hierarchyid-data-type-method-reference.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -69,8 +69,8 @@ If a user type with conflicting name exists during the upgrade, no special steps
6969
Columns of type **hierarchyid** can be used on any replicated table. The requirements for your application depend on whether replication is one directional or bidirectional, and on the versions of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] that are used.
7070

7171
### One-directional replication
72-
One-directional replication includes snapshot replication, transactional replication, and merge replication in which changes are not made at the Subscriber. How **hierachyid** columns work with one directional replication depends on the version of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] the Subscriber is running.
73-
- A [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Publisher can replicate **hierachyid** columns to a [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Subscriber without any special considerations.
72+
One-directional replication includes snapshot replication, transactional replication, and merge replication in which changes are not made at the Subscriber. How **hierarchyid** columns work with one directional replication depends on the version of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] the Subscriber is running.
73+
- A [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Publisher can replicate **hierarchyid** columns to a [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Subscriber without any special considerations.
7474
- A [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] Publisher must convert **hierarchyid** columns to replicate them to a Subscriber that is running [!INCLUDE[ssEW](../../includes/ssew-md.md)] or an earlier version of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. [!INCLUDE[ssEW](../../includes/ssew-md.md)] and earlier versions of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] do not support **hierarchyid** columns. If you are using one of these versions, you can still replicate data to a Subscriber. To do this, you must set a schema option or the publication compatibility level (for merge replication) so the column can be converted to a compatible data type.
7575

7676
Column filtering is supported in both of these scenarios. This includes filtering out **hierarchyid** columns. Row filtering is supported as long as the filter does not include a **hierarchyid** column.

‎docs/t-sql/database-console-commands/dbcc-freeproccache-transact-sql.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -86,7 +86,7 @@ DBCC FREEPROCCACHE [ ( COMPUTE | ALL ) ]
8686
## Remarks
8787
Use DBCC FREEPROCCACHE to clear the plan cache carefully. Clearing the procedure (plan) cache causes all plans to be evicted, and incoming query executions will compile a new plan, instead of reusing any previously cached plan.
8888

89-
This can cause a sudden, temporary decrease in query performance as the number of new compilations increases. For each cleared cachestore in the plan cache, the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] error log will contain the following informational message: " [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations." This message is logged every five minutes as long as the cache is flushed within that time interval.
89+
This can cause a sudden, temporary decrease in query performance as the number of new compilations increases. For each cleared cachestore in the plan cache, the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] error log will contain the following informational message: " [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations." This message is logged every five minutes as long as the cache is flushed within that time interval.
9090

9191
The following reconfigure operations also clear the procedure cache:
9292
- access check cache bucket count
@@ -126,7 +126,7 @@ DBCC FREEPROCCACHE can be cancelled during execution.
126126

127127
## Limitations and Restrictions for [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]
128128
DBCC FREEPROCCACHE can not run within a transaction.
129-
DBCC FREEPROCCAHCE is not supported in an EXPLAIN statement.
129+
DBCC FREEPROCCACHE is not supported in an EXPLAIN statement.
130130

131131
## Metadata for [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]
132132
A new row is added to the sys.pdw_exec_requests system view when DBCC FREEPROCCACHE is run.

‎docs/t-sql/database-console-commands/dbcc-pdw-showexecutionplan-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -83,7 +83,7 @@ AND pdw_node_id = 201001
8383
order by request_id, [dms_step_index], [distribution_id];
8484
```
8585

86-
Based on the results of the preceding query, use the sql_spid and pdw_node_id as parameters to DBCC PDW_SHOWEXEUCTIONPLAN. For example, the following command shows the execution plan for pdw_node_id 201001 and sql_spid 375.
86+
Based on the results of the preceding query, use the sql_spid and pdw_node_id as parameters to DBCC PDW_SHOWEXECUTIONPLAN. For example, the following command shows the execution plan for pdw_node_id 201001 and sql_spid 375.
8787

8888
```sql
8989
DBCC PDW_SHOWEXECUTIONPLAN ( 201001, 375 );

‎docs/t-sql/functions/applock-test-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -44,7 +44,7 @@ The user, role, or application role that can be granted permissions to objects i
4444
A lock resource name specified by the client application. The application must ensure a unique resource name. The specified name is hashed internally into a value that the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] lock manager can internally store. *resource_name*is **nvarchar(255)**, with no default. *resource_name* is binary compared, and is case-sensitive regardless of the collation settings of the current database.
4545

4646
**'** *lock_mode* **'**
47-
The lock mode to obtaine for a specific resource. *lock_mode* is **nvarchar(32)**, with no default value. *lock_mode* can have any of these values: **Shared**, **Update**, **IntentShared**, **IntentExclusive**, **Exclusive**.
47+
The lock mode to obtain for a specific resource. *lock_mode* is **nvarchar(32)**, with no default value. *lock_mode* can have any of these values: **Shared**, **Update**, **IntentShared**, **IntentExclusive**, **Exclusive**.
4848

4949
**'** *lock_owner* **'**
5050
The owner of the lock, which is the *lock_owner* value when the lock was requested. *lock_owner* is **nvarchar(32)**, and the value can be either **Transaction** (the default) or **Session**. If default or **Transaction** is explicitly specified, APPLOCK_TEST must be executed from within a transaction.

‎docs/t-sql/functions/char-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -13,7 +13,7 @@ f1_keywords:
1313
dev_langs:
1414
- "TSQL"
1515
helpviewer_keywords:
16-
- "converting int ACSII code to character"
16+
- "converting int ASCII code to character"
1717
- "control characters"
1818
- "tab"
1919
- "ASCII conversions"

‎docs/t-sql/functions/columnproperty-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -55,7 +55,7 @@ For the *id* argument, the *property* argument specifies the information type th
5555
|**IsCursorType**|Procedure parameter is of type CURSOR.|1: TRUE<br /><br /> 0: FALSE<br /><br /> NULL: invalid input.|
5656
|**IsDeterministic**|Column is deterministic. This property applies only to computed columns and view columns.|1: TRUE<br /><br /> 0: FALSE<br /><br /> NULL: invalid input. Not a computed column or view column.|
5757
|**IsFulltextIndexed**|Column is registered for full-text indexing.|1: TRUE<br /><br /> 0: FALSE<br /><br /> NULL: invalid input.|
58-
|**IsHidden**|Is column value sysem-generated. Corresponds to **sys.columns.is_hidden**|**Applies to**: [!INCLUDE[ssCurrentLong](../../includes/sscurrent-md.md)] through [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].<br /><br /> 0: Not hidden<br /><br /> 1: Hidden|
58+
|**IsHidden**|Is column value system-generated. Corresponds to **sys.columns.is_hidden**|**Applies to**: [!INCLUDE[ssCurrentLong](../../includes/sscurrent-md.md)] through [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].<br /><br /> 0: Not hidden<br /><br /> 1: Hidden|
5959
|**IsIdentity**|Column uses the IDENTITY property.|1: TRUE<br /><br /> 0: FALSE<br /><br /> NULL: invalid input.|
6060
|**IsIdNotForRepl**|Column checks for the IDENTITY_INSERT setting.|1: TRUE<br /><br /> 0: FALSE<br /><br /> NULL: invalid input.|
6161
|**IsIndexable**|Column can be indexed.|1: TRUE<br /><br /> 0: FALSE<br /><br /> NULL: invalid input.|

‎docs/t-sql/functions/cryptographic-functions-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -41,7 +41,7 @@ These functions support digital signing, digital signature validation, encryptio
4141
|||
4242
|-|-|
4343
|[ENCRYPTBYASYMKEY](../../t-sql/functions/encryptbyasymkey-transact-sql.md)|[DECRYPTBYASYMKEY](../../t-sql/functions/decryptbyasymkey-transact-sql.md)|
44-
|[ENCRYPTBYCert](../../t-sql/functions/encryptbycert-transact-sql.md)|[DECRYPTBYCERT](../../t-sql/functions/decryptbycert-transact-sql.md)|
44+
|[ENCRYPTBYCERT](../../t-sql/functions/encryptbycert-transact-sql.md)|[DECRYPTBYCERT](../../t-sql/functions/decryptbycert-transact-sql.md)|
4545
|[ASYMKEYPROPERTY](../../t-sql/functions/asymkeyproperty-transact-sql.md)|[ASYMKEY_ID](../../t-sql/functions/asymkey-id-transact-sql.md)|
4646

4747
## Signing and signature verification

‎docs/t-sql/functions/cume-dist-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -45,7 +45,7 @@ The *partition_by_clause* divides the FROM clause result set into partitions, to
4545
**float(53)**
4646

4747
## Remarks
48-
`CUME_DIST` returns a range of values greater tnan 0 and less than or equal to 1. Tie values always evaluate to the same cumulative distribution value. `CUME_DIST` includes NULL values by default and treats these values as the lowest possible values.
48+
`CUME_DIST` returns a range of values greater than 0 and less than or equal to 1. Tie values always evaluate to the same cumulative distribution value. `CUME_DIST` includes NULL values by default and treats these values as the lowest possible values.
4949

5050
`CUME_DIST` is nondeterministic. See [Deterministic and Nondeterministic Functions](../../relational-databases/user-defined-functions/deterministic-and-nondeterministic-functions.md) for more information.
5151

‎docs/t-sql/functions/dense-rank-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -93,7 +93,7 @@ ProductID Name LocationID Quantity Rank
9393
```
9494

9595
### B. Ranking all rows in a result set
96-
This example returns the top ten employees ranked by their salary. Because the `SELECT` statement did not specifiy a `PARTITION BY` clause, the `DENSE_RANK` function applied to all result set rows.
96+
This example returns the top ten employees ranked by their salary. Because the `SELECT` statement did not specify a `PARTITION BY` clause, the `DENSE_RANK` function applied to all result set rows.
9797

9898
```
9999
USE AdventureWorks2012;

0 commit comments

Comments
 (0)