StackOverflow Questions for Tag: openrowset

Radioleao

Reputation: 404

Create new Excel Sheet with SQL Server OPENROWSET

sql-serverexcelopenrowsetaceoledb

Score: 0

Answers: 0

osm0sis

Reputation: 31

Getting 'Attribute "FIELDQUOTE" could not be specified for this type' when using .xml format file for a T-SQL OPENROWSET BULK Query

sql-serverxmlt-sqlbcpopenrowset

Score: 0

Answers: 0

Clayton A. Santos

Reputation: 397

How to list all parquet files in s3 bucket folder via OPENROWSET (SQL Server)?

pythonsql-serveramazon-web-servicesopenrowset

Score: 1

Answers: 2

Gbade Aina

Reputation: 1

Error Message When Executing Using Direct Query to execute a stored procedure with parameters in Power BI

sql-serverpowerbiopenrowsetdirectquery

Score: 0

Answers: 0

RaffaeleT

Reputation: 264

OPENROWSET Bulk Load multiple JSON files from Azure Blob Storage

sql-serverazure-blob-storageopenrowsetbulk-load

Score: 0

Answers: 1

Sunil Jadhav

Reputation: 71

How to load complex JSON data into SQL Server table where there are multiple tables

sqljsonsql-serveropenrowset

Score: 0

Answers: 0

Pingyao

Reputation: 109

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

sqlazure-synapseopenrowset

Score: 0

Answers: 2

SantoshGupta7

Reputation: 6197

Syntax issue in SQL Server, using OPENROWSET

sqlsql-servert-sqlconcatenationopenrowset

Score: 1

Answers: 3

fiberOptics

Reputation: 7165

INSERT INTO from two different server database

sqlsql-serveropenrowset

Score: 33

Answers: 7

steve_flynn

Reputation: 45

Best way to automate processing of daily XML files into SQL database

sql-serverxmlopenrowset

Score: 1

Answers: 2

VBStarr

Reputation: 686

Want to use OPENROWSET to open Local XML file in SQL Server

sql-serverxmlopenrowset

Score: 1

Answers: 3

Control Freak

Reputation: 13243

Using a Variable in OPENROWSET Query

sqlsql-serversql-server-2008openrowset

Score: 37

Answers: 6

bbb0777

Reputation: 309

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

azureazure-synapseopenrowset

Score: 0

Answers: 2

el_pazzu

Reputation: 416

Azure Synapse SQL pool not identifying csv headers using OPENROWSET

azuret-sqlazure-synapseopenrowsetazure-synapse-analytics

Score: 0

Answers: 1

Jules_

Reputation: 1

SQL Server OPENROWSET Msg 7302 Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

sql-serveroledbopenrowsetexcel-import

Score: 0

Answers: 0

Chris

Reputation: 798

Classic ASP SQL openrowset query with UNC is being denied because of permissions when it previously worked

sql-serverpermissionsuncopenrowset

Score: 0

Answers: 0

Wonwoo Jeon

Reputation: 1

How to use the OPENROWSET without setting Ad Hoc Distributed Queries to true?

sqlsql-serveropenrowsetadhoc-queries

Score: 0

Answers: 0

Shishir Tanwar

Reputation: 21

Dynamic query to read XML file using OpenRowSet executes manually but not with SP_Execute

sqlxmlfileopenrowsetdynamicquery

Score: 0

Answers: 1

Hunderfert

Reputation: 41

OPENROWSET SSMS to import excel file

sql-serveropenrowset

Score: 1

Answers: 1

Sara

Reputation: 9

how to set bulk_options in openrowset to read file from Azure blob storage?

azure-sql-databaseazure-blob-storageopenrowset

Score: -1

Answers: 2

PreviousPage 2Next

StackOverflow Questions for Tag: openrowset

Create new Excel Sheet with SQL Server OPENROWSET

Getting &#39;Attribute &quot;FIELDQUOTE&quot; could not be specified for this type&#39; when using .xml format file for a T-SQL OPENROWSET BULK Query

How to list all parquet files in s3 bucket folder via OPENROWSET (SQL Server)?

Error Message When Executing Using Direct Query to execute a stored procedure with parameters in Power BI

OPENROWSET Bulk Load multiple JSON files from Azure Blob Storage

How to load complex JSON data into SQL Server table where there are multiple tables

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

Syntax issue in SQL Server, using OPENROWSET

INSERT INTO from two different server database

Best way to automate processing of daily XML files into SQL database

Want to use OPENROWSET to open Local XML file in SQL Server

Using a Variable in OPENROWSET Query

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

Azure Synapse SQL pool not identifying csv headers using OPENROWSET

SQL Server OPENROWSET Msg 7302 Cannot create an instance of OLE DB provider &quot;Microsoft.ACE.OLEDB.12.0&quot; for linked server &quot;(null)&quot;

Classic ASP SQL openrowset query with UNC is being denied because of permissions when it previously worked

How to use the OPENROWSET without setting Ad Hoc Distributed Queries to true?

Dynamic query to read XML file using OpenRowSet executes manually but not with SP_Execute

OPENROWSET SSMS to import excel file

how to set bulk_options in openrowset to read file from Azure blob storage?

Getting 'Attribute "FIELDQUOTE" could not be specified for this type' when using .xml format file for a T-SQL OPENROWSET BULK Query

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

SQL Server OPENROWSET Msg 7302 Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"