Skip to content

Commit b206936

Browse files
huypubhuypub
authored
Merge pull request #12877 from MicrosoftDocs/FromPublicRepo
Confirm merge from FromPublicRepo to master to sync with https://github.com/MicrosoftDocs/sql-docs (branch live)
2 parents ccef0b1 + 3c27502 commit b206936

6 files changed

Lines changed: 12 additions & 10 deletions

File tree

‎docs/relational-databases/security/authentication-access/create-a-database-user.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -28,7 +28,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
2828
# Create a Database User
2929
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
3030

31-
This topic describes how to create the most common types of database users. There are eleven type of users. The complete list is provided in the topic [CREATE USER (Transact-SQL)](../../../t-sql/statements/create-user-transact-sql.md). All varieties of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] support database users, but not necessarily all types of users.
31+
This topic describes how to create the most common types of database users. There are eleven types of users. The complete list is provided in the topic [CREATE USER (Transact-SQL)](../../../t-sql/statements/create-user-transact-sql.md). All varieties of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] support database users, but not necessarily all types of users.
3232

3333
You can create a database user by using [!INCLUDE[ssManStudioFull](../../../includes/ssmanstudiofull-md.md)] or by using [!INCLUDE[tsql](../../../includes/tsql-md.md)].
3434

‎docs/relational-databases/system-catalog-views/sys-index-resumable-operations.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -24,8 +24,8 @@ monikerRange: "=azuresqldb-current||>=sql-server-2017||=sqlallproducts-allversio
2424
# sys.index_resumable_operations (Transact-SQL)
2525

2626
[!INCLUDE[tsql-appliesto-ss2017-asdb-xxxx-xxx-md](../../includes/tsql-appliesto-ss2017-asdb-xxxx-xxx-md.md)]
27-
**sys.index_resumable_operations** is a system view that monitors and checks the current execution status for resumable Index rebuild.
28-
**Applies to**: SQL Server (2017 and newer) and Azure SQL Database
27+
**sys.index_resumable_operations** is a system view that monitors and checks the current execution status for resumable Index rebuild or creation.
28+
**Applies to**: SQL Server (2017 and newer), and Azure SQL Database
2929

3030
|Column name|Data type|Description|
3131
|-----------------|---------------|-----------------|
@@ -49,7 +49,7 @@ monikerRange: "=azuresqldb-current||>=sql-server-2017||=sqlallproducts-allversio
4949

5050
## Example
5151

52-
List all resumable index rebuild operations that are in the PAUSE state.
52+
List all resumable index creation or rebuild operations that are in the PAUSE state.
5353

5454
```sql
5555
SELECT * FROM sys.index_resumable_operations WHERE STATE = 1;

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -118,10 +118,10 @@ The following tables list the [!INCLUDE[tsql](../../includes/tsql-md.md)] date a
118118
|Function|Syntax|Return value|Return data type|Determinism|
119119
|---|---|---|---|---|
120120
|[@@DATEFIRST](../../t-sql/functions/datefirst-transact-sql.md)|@@DATEFIRST|Returns the current value, for the session, of SET DATEFIRST.|**tinyint**|Nondeterministic|
121-
|[SET DATEFIRST](../../t-sql/statements/set-datefirst-transact-sql.md)|SET DATEFIRST { *number* | **@***number_var* }|Sets the first day of the week to a number from 1 through 7.|Not applicable|Not applicable|
121+
|[SET DATEFIRST](../../t-sql/statements/set-datefirst-transact-sql.md)|SET DATEFIRST { *number* | **\@**_number_var_ }|Sets the first day of the week to a number from 1 through 7.|Not applicable|Not applicable|
122122
|[SET DATEFORMAT](../../t-sql/statements/set-dateformat-transact-sql.md)|SET DATEFORMAT { *format* | **@**_format_var_ }|Sets the order of the dateparts (month/day/year) for entering **datetime** or **smalldatetime** data.|Not applicable|Not applicable|
123123
|[@@LANGUAGE](../../t-sql/functions/language-transact-sql.md)|@@LANGUAGE|Returns the name of the language in current used. @@LANGUAGE is not a date or time function. However, the language setting can affect the output of date functions.|Not applicable|Not applicable|
124-
|[SET LANGUAGE](../../t-sql/statements/set-language-transact-sql.md)|SET LANGUAGE { [ N ] **'**_language_**'** | **@***language_var* }|Sets the language environment for the session and system messages. SET LANGUAGE is not a date or time function. However, the language setting affects the output of date functions.|Not applicable|Not applicable|
124+
|[SET LANGUAGE](../../t-sql/statements/set-language-transact-sql.md)|SET LANGUAGE { [ N ] **'**_language_**'** | **\@**_language_var_ }|Sets the language environment for the session and system messages. SET LANGUAGE is not a date or time function. However, the language setting affects the output of date functions.|Not applicable|Not applicable|
125125
|[sp_helplanguage](../../relational-databases/system-stored-procedures/sp-helplanguage-transact-sql.md)|**sp_helplanguage** [ [ **@language =** ] **'**_language_**'** ]|Returns information about date formats of all supported languages. **sp_helplanguage** is not a date or time stored procedure. However, the language setting affects the output of date functions.|Not applicable|Not applicable|
126126

127127
### <a name="ValidateDateandTimeValues"></a> Functions That Validate Date and Time Values

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

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -39,11 +39,11 @@ ms.author: mikeray
3939
## Remarks
4040
The options can come from use of the **SET** command or from the **sp_configure user options** value. Session values configured with the **SET** command override the **sp_configure** options. Many tools (such as [!INCLUDE[ssManStudio](../../includes/ssmanstudio-md.md)] automatically configure set options. Each user has an @@OPTIONS function that represents the configuration.
4141

42-
You can change the language and query-processing options for a specific user session by using the SET statement. **@@OPTIONS** can only detect the options which are set to ON or OFF.
42+
You can change the language and query-processing options for a specific user session by using the SET statement. **\@\@OPTIONS** can only detect the options which are set to ON or OFF.
4343

44-
The **@@OPTIONS** function returns a bitmap of the options, converted to a base 10 (decimal) integer. The bit settings are stored in the locations described in a table in the topic [Configure the user options Server Configuration Option](../../database-engine/configure-windows/configure-the-user-options-server-configuration-option.md).
44+
The **\@\@OPTIONS** function returns a bitmap of the options, converted to a base 10 (decimal) integer. The bit settings are stored in the locations described in a table in the topic [Configure the user options Server Configuration Option](../../database-engine/configure-windows/configure-the-user-options-server-configuration-option.md).
4545

46-
To decode the **@@OPTIONS** value, convert the integer returned by **@@OPTIONS** to binary, and then look up the values on the table at [Configure the user options Server Configuration Option](../../database-engine/configure-windows/configure-the-user-options-server-configuration-option.md). For example, if `SELECT @@OPTIONS;` returns the value `5496`, use the Windows programmer calculator (**calc.exe**) to convert decimal `5496` to binary. The result is `1010101111000`. The right most characters (binary 1, 2, and 4) are 0, indicating that the first three items in the table are off. Consulting the table, you see that those are **DISABLE_DEF_CNST_CHK** and **IMPLICIT_TRANSACTIONS**, and **CURSOR_CLOSE_ON_COMMIT**. The next item (**ANSI_WARNINGS** in the `1000` position) is on. Continue working left though the bit map, and down in the list of options. When the left-most options are 0, they are truncated by the type conversion. The bit map `1010101111000` is actually `001010101111000` to represent all 15 options.
46+
To decode the **\@\@OPTIONS** value, convert the integer returned by **\@\@OPTIONS** to binary, and then look up the values on the table at [Configure the user options Server Configuration Option](../../database-engine/configure-windows/configure-the-user-options-server-configuration-option.md). For example, if `SELECT @@OPTIONS;` returns the value `5496`, use the Windows programmer calculator (**calc.exe**) to convert decimal `5496` to binary. The result is `1010101111000`. The right most characters (binary 1, 2, and 4) are 0, indicating that the first three items in the table are off. Consulting the table, you see that those are **DISABLE_DEF_CNST_CHK** and **IMPLICIT_TRANSACTIONS**, and **CURSOR_CLOSE_ON_COMMIT**. The next item (**ANSI_WARNINGS** in the `1000` position) is on. Continue working left though the bit map, and down in the list of options. When the left-most options are 0, they are truncated by the type conversion. The bit map `1010101111000` is actually `001010101111000` to represent all 15 options.
4747

4848
## Examples
4949

‎docs/t-sql/statements/create-external-data-source-transact-sql.md‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -217,6 +217,8 @@ WITH
217217
( LOCATION = 'oracle://145.145.145.145:1521'
218218
, CREDENTIAL = OracleProxyAccount
219219
, PUSHDOWN = ON
220+
, TYPE=BLOB_STORAGE
221+
)
220222
;
221223
```
222224

‎docs/t-sql/statements/delete-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -242,7 +242,7 @@ WHERE StandardCost > 1000.00;
242242
GO
243243
```
244244

245-
The following example shows a more complex WHERE clause. The WHERE clause defines two conditions that must be met to determine the rows to delete. The value in the `StandardCost` column must be between `12.00` and `14.00` and the value in the column `SellEndDate` must be null. The example also prints the value from the **@@ROWCOUNT** function to return the number of deleted rows.
245+
The following example shows a more complex WHERE clause. The WHERE clause defines two conditions that must be met to determine the rows to delete. The value in the `StandardCost` column must be between `12.00` and `14.00` and the value in the column `SellEndDate` must be null. The example also prints the value from the **\@\@ROWCOUNT** function to return the number of deleted rows.
246246

247247
```sql
248248
DELETE Production.ProductCostHistory

0 commit comments

Comments
 (0)