Skip to content
This repository was archived by the owner on Apr 20, 2019. It is now read-only.

Commit badcf8d

Browse files
authored
Update col-length-transact-sql.md
Text revisions to tighten and optimize the reading flow of the material.
1 parent f3aa02a commit badcf8d

1 file changed

Lines changed: 7 additions & 7 deletions

File tree

docs/t-sql/functions/col-length-transact-sql.md

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -32,7 +32,7 @@ ms.workload: "On Demand"
3232
# COL_LENGTH (Transact-SQL)
3333
[!INCLUDE[tsql-appliesto-ss2008-asdb-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md)]
3434

35-
Returns the defined length, in bytes, of a column.
35+
This function returns the defined length of a column, in bytes.
3636

3737
![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
3838

@@ -44,24 +44,24 @@ COL_LENGTH ( 'table' , 'column' )
4444

4545
## Arguments
4646
**'** *table* **'**
47-
Is the name of the table for which to determine column length information. *table* is an expression of type **nvarchar**.
47+
The name of the table whose column length information we want to determine. *table* is an expression of type **nvarchar**.
4848

4949
**'** *column* **'**
50-
Is the name of the column for which to determine length. *column* is an expression of type **nvarchar**.
50+
The column name whose length we want to determine. *column* is an expression of type **nvarchar**.
5151

5252
## Return type
5353
**smallint**
5454

5555
## Exceptions
56-
Returns NULL on error or if a caller does not have permission to view the object.
56+
Returns NULL on error, or if a caller does not have the correct permission to view the object.
5757

58-
In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], a user can only view the metadata of securables that the user owns or on which the user has been granted permission. This means that metadata-emitting, built-in functions such as COL_LENGTH may return NULL if the user does not have any permission on the object. For more information, see [Metadata Visibility Configuration](../../relational-databases/security/metadata-visibility-configuration.md).
58+
In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], a user can only view the metadata of securables that the user owns, or on which the user has been granted permission. This means that metadata-emitting, built-in functions such as COL_LENGTH might return NULL, if the user does not have correct permission on the object. See [Metadata Visibility Configuration](../../relational-databases/security/metadata-visibility-configuration.md) for more information.
5959

6060
## Remarks
61-
For columns of type **varchar** declared with the **max** specifier (**varchar(max)**), COL_LENGTH returns the value –1.
61+
For **varchar** columns declared with the **max** specifier (**varchar(max)**), COL_LENGTH returns the value –1.
6262

6363
## Examples
64-
The following example shows the return values for a column of type `varchar(40)` and a column of type `nvarchar(40)`.
64+
This example shows the return values for a column of type `varchar(40)` and a column of type `nvarchar(40)`:
6565

6666
```sql
6767
USE AdventureWorks2012;

0 commit comments

Comments
 (0)