openrowset Examples and Free Source Code

Query Amazon S3 file via OPENROWSET with SQL Server 2022...

amazon-s3 openrowset sql-server-2022

Using OPENROWSET to dynamically retrieve SP results when SP contains # temp tables...

sql sql-server t-sql dynamic-sql openrowset

The metadata could not be determined because every code path results in an error; see previous error...

sql metadata sql-server-2014 openrowset

How to create and populate a table in a single step as part of a CSV import operation?...

sql-server sql-server-2000 bulkinsert create-table openrowset

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"...

sql visual-studio-2013 openrowset

OPENROWSET only accepting VARCHAR/NVARCHAR for a Date column in a CSV, not DATE (Synapse Serverless)...

sql azure-synapse openrowset

Syntax issue in SQL Server, using OPENROWSET...

sql sql-server t-sql concatenation openrowset

Using a Variable in OPENROWSET Query...

sql sql-server sql-server-2008 openrowset

Grant a login SELECT on some Synapse Serverless Views, but not ability to run OPENROWSET on *entire*...

azure azure-synapse openrowset

Azure Synapse SQL pool not identifying csv headers using OPENROWSET...

azure t-sql azure-synapse openrowset azure-synapse-analytics

Synapse Analytics query fails when arguments for WHERE-IN operator contains colon like ('asdf:as...

t-sql escaping special-characters azure-synapse openrowset

XML data to SQL tables, difficulty gettting child node data...

xml xquery xquery-sql openrowset

Escape characters in .csv for Azure Synapse seems to dissapear?...

azure csv azure-synapse openrowset

OPENROWSET with Excel file returns DBSCHEMA_TABLES_INFO error...

sql-server excel oledb openrowset

Unable to remove red underlines for XML import object in SQL Server Select...

sql sql-server t-sql xquery openrowset

Trying to avoid nested insert-exec using openrowset, but getting weird permissions error...

sql-server openrowset

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server &q...

sql-server-2005 openrowset msdasql

T-SQL OPENROWSET - Datasource...

t-sql azure-sql-database azure-data-lake-gen2 openrowset

MS SQL Server 2019 OpenRowSet Bulk Insert with CSV file - (0 rows affected)...

sql-server insert ssms bulk openrowset

Few issues Inserting and filtering XML data to SQL...

sql sql-server xml database openrowset

How to export data delimited by semicolon using OPENROWSET?...

t-sql export sql-server-2016 openrowset

How to add a dynamic URL inside an OPENROW SET...

sql sql-server select azure-sql-database openrowset

Query data from a text file and get a JSON column...

sql json sql-server t-sql openrowset

T-SQL: issue with string concat...

t-sql sql-server-2008 string-concatenation openrowset

SQL Server bulk openrowset access is denied for windows user but not for sa...

sql-server bulk openrowset

How to use a variable in Openrowset command...

sql sql-server openrowset

How not to update a column if a file path is null or file doesn't exist?...

sql sql-update openrowset

SQL Server Serverless - Openrowset - Metadata functions?...

sql metadata azure-synapse openrowset

Is there a way to reserve generated ID on a temporary table...

sql-server openxml openrowset open-json

Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null...

sql sql-server export-to-excel openrowset