Skip to content

Commit dcabdfa

Browse files
authored
removed sql colorizers from the output
and capitalized the keywords
1 parent 18966fb commit dcabdfa

1 file changed

Lines changed: 6 additions & 6 deletions

File tree

docs/t-sql/functions/openrowset-transact-sql.md

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -394,8 +394,8 @@ FROM Northwind.dbo.Customers AS c
394394
The following example creates a small table for demonstration purposes, and inserts file data from a file named `Text1.txt` located in the `C:` root directory into a `varbinary(max)` column.
395395

396396
```sql
397-
CREATE TABLE myTable(FileName nvarchar(60),
398-
FileType nvarchar(60), Document varbinary(max));
397+
CREATE TABLE myTable(FileName NVARCHAR(60),
398+
FileType NVARCHAR(60), Document VARBINARY(max));
399399
GO
400400

401401
INSERT INTO myTable(FileName, FileType, Document)
@@ -414,15 +414,15 @@ GO
414414

415415
The following example uses a format file to retrieve rows from a tab-delimited text file, `values.txt` that contains the following data:
416416

417-
```sql
417+
```
418418
1 Data Item 1
419419
2 Data Item 2
420420
3 Data Item 3
421421
```
422422

423423
The format file, `values.fmt`, describes the columns in `values.txt`:
424424

425-
```sql
425+
```
426426
9.0
427427
2
428428
1 SQLCHAR 0 10 "\t" 1 ID SQL_Latin1_General_Cp437_BIN
@@ -473,8 +473,8 @@ SELECT * FROM OPENROWSET(
473473
```
474474

475475
```sql
476-
select *
477-
from openrowset
476+
SELECT *
477+
FROM OPENROWSET
478478
( 'MSDASQL'
479479
,'Driver={Microsoft Access Text Driver (*.txt, *.csv)}'
480480
,'select * from E:\Tlog\TerritoryData.csv')

0 commit comments

Comments
 (0)