Questions about openrowset
Read more about openrowset
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
T-SQL OPENROWSET - Datasource
I am using T-SQL to query a storage account container in the Azure Data Lake Gen 2.
At the moment I have the following query where I supply the entire path to the CSV file:
SELECT *
FROM OPENROWSET(...
Stanza
Votes: 0
Answers: 1
When using OPENROWSET, how can I filter out non-numeric rows of a specific column?
I'm using OPENROWSET to import regular csv data files into a SQL table. Very occasionally one of the columns (which is supposed to be a SMALLINT) contains the value 'UNKNOWN', which obviously causes a...
Cam
Votes: 0
Answers: 0
MS SQL Server 2019 OpenRowSet Bulk Insert with CSV file - (0 rows affected)
I am attempting to load a CSV file onto MS SQL Server with OPENROWSET BULK INSERT and 0 rows are being inserted.
I am using the following code within SQL Server Management Studio;
-- DROP TABLE finan...
keoghb
Votes: 0
Answers: 1
Few issues Inserting and filtering XML data to SQL
I'm having a few issues when inserting data from a XML file to a SQL Server database.
How can I get the file name dynamically? This file is put on that path with a different number every time but alw...
KnockOutMan2015
Votes: 0
Answers: 1