var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OPENROWSET only returns first row
I've got some text files that I need to read and make some calculations, before inserting data into a table.
When I use:
it only retrieves the first row. How can I select all the lines in the file?
select BulkColumn as txt from openrowset(BULK 'c:\Temp\data\035.txt', SINGLE_NCLOB) as text
Using "SINGLE_NCLOB" will return the contents of the file as a single row:
If you want to return the file as multiple rows, you may need to look into a format file, where you define a row terminator.
Originally Posted by BOL