|
There's no doubt OPENSTRING is really cool... but how do I preserve the input row/line number ordering? With LOAD TABLE, this technique works: DECLARE LOCAL TEMPORARY TABLE raw_text (
line_number BIGINT NOT NULL
DEFAULT AUTOINCREMENT
PRIMARY KEY CLUSTERED,
line_text LONG VARCHAR NOT NULL DEFAULT '' )
NOT TRANSACTIONAL;
LOAD TABLE raw_text ( line_text )
USING VALUE @whatever
DEFAULTS ON
DELIMITED BY ''
ESCAPES OFF
HEXADECIMAL OFF
QUOTES OFF
STRIP OFF;
|
|
select rowid( tab ), * from openstring( VALUE @whatever ) WITH( ...schema... ) tab |
