Skip to content

Commit 0918764

Browse files
authored
capitalized the keywords
1 parent cfbf1c3 commit 0918764

1 file changed

Lines changed: 3 additions & 3 deletions

File tree

docs/t-sql/data-types/sql-variant-transact-sql.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -123,13 +123,13 @@ The following lists the types of values that cannot be stored by using **sql_var
123123
The following example, creates a table with a sql_variant data type. Then the example retrieves `SQL_VARIANT_PROPERTY` information about the `colA` value `46279.1` where `colB` =`1689`, given that `tableA` has `colA` that is of type `sql_variant` and `colB`.
124124

125125
```sql
126-
CREATE TABLE tableA(colA sql_variant, colB int)
127-
INSERT INTO tableA values ( cast (46279.1 as decimal(8,2)), 1689)
126+
CREATE TABLE tableA(colA sql_variant, colB INT)
127+
INSERT INTO tableA values ( CAST(46279.1 as decimal(8,2)), 1689)
128128
SELECT SQL_VARIANT_PROPERTY(colA,'BaseType') AS 'Base Type',
129129
SQL_VARIANT_PROPERTY(colA,'Precision') AS 'Precision',
130130
SQL_VARIANT_PROPERTY(colA,'Scale') AS 'Scale'
131131
FROM tableA
132-
WHERE colB = 1689
132+
WHERE colB = 1689
133133
```
134134

135135
[!INCLUDE[ssResult](../../includes/ssresult-md.md)] Note that each of these three values is a **sql_variant**.

0 commit comments

Comments
 (0)