StackOverflow Questions for Tag: openrowset

humanistitel

Reputation: 13

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

t-sqlescapingspecial-charactersazure-synapseopenrowset

Score: 0

Answers: 1

Lucifer Rodstark

Reputation: 216

SQL Server Access to Disk C

sql-serverexcelwindowsstored-proceduresopenrowset

Score: 0

Answers: 0

DEV123

Reputation: 1

Change the collation of fields when using OpenRowSet

sqlsql-servercollationopenrowset

Score: 0

Answers: 0

Pflipper

Reputation: 88

XML data to SQL tables, difficulty gettting child node data

xmlxqueryxquery-sqlopenrowset

Score: 0

Answers: 1

Varinder Verma

Reputation: 13

How to select dynamic sheet Name in Openrow set in SQL query?

sqlsql-serveropenrowset

Score: 0

Answers: 2

marritza

Reputation: 52

Allowing @ symbol in connection string for OPENROWSET from Synapse

sql-serverazure-synapseopenrowsetdata-lakehouse

Score: 0

Answers: 1

Snehal Panchal

Reputation: 1

Create ##temp table and insert the rows to an existing table only wherever the columns match

sqlmappingfieldtempopenrowset

Score: 0

Answers: 0

Mark

Reputation: 75

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

azurecsvazure-synapseopenrowset

Score: 0

Answers: 1

jfish

Reputation: 106

Getting A transport-level error when executing OPENROWSET

sqlopenrowset

Score: 0

Answers: 3

rvunen

Reputation: 1

Filestream and using bulk insert via OPENROWSET gives File could not be opened. Operating system error code 50(The request is not supported.)

sql-serverwindowsbulkinsertopenrowsetsqlfilestream

Score: 0

Answers: 1

Anubhav

Reputation: 365

I am getting an error Incorrect syntax near 'OPENROWSET'. while using openrowset function on dedicated SQL Pool

t-sqlazure-functionsazure-synapseopenrowset

Score: -1

Answers: 3

fidou

Reputation: 11

Executing an OPENROWSET on azure synapse result in a 'Resolving CosmosDB path has failed with error 'Secret is not base64 encoded.''

azureazure-cosmosdbcredentialsazure-synapseopenrowset

Score: 0

Answers: 2

Sunil Jadhav

Reputation: 71

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if 'yes' then how?

sql-serverxmlopenrowsetouter-applywith-clause

Score: 0

Answers: 1

Bruno

Reputation: 21

How to allow all users to run this SQL query?

sqlsql-serveropenrowset

Score: 0

Answers: 0

ahmed barbary

Reputation: 670

Can't access Excel file from Python and get error No such file or directory?

python-3.xpandast-sqlsql-server-2019openrowset

Score: 0

Answers: 1

Sree

Reputation: 121

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered

sql-serveroledbopenrowsetaceoledb

Score: 2

Answers: 0

D3Young

Reputation: 35

Skip LAST Line with OPENROWSET

sql-servercsvopenrowsetnocount

Score: 1

Answers: 4

MGilbert

Reputation: 41

Openrowset but select only specific columns from file

sqlopenrowset

Score: 0

Answers: 1

Depth of Field

Reputation: 317

Getting "7302 - Cannot Create an instance of OLE DB" Error after ACE/ODBC Driver update

sql-serverodbcopenrowsetmsdasqlaccess-database-engine

Score: 0

Answers: 1

Tomas Vileikis

Reputation: 47

I have an Excel file with a table and additional text (comments) on the same sheet. I want to extract ONLY the table. How can I do this in SQL?

sqlexcelopenrowset

Score: 1

Answers: 0

PreviousPage 3Next

StackOverflow Questions for Tag: openrowset

Synapse Analytics query fails when arguments for WHERE-IN operator contains colon like (&#39;asdf:asdf&#39;)

SQL Server Access to Disk C

Change the collation of fields when using OpenRowSet

XML data to SQL tables, difficulty gettting child node data

How to select dynamic sheet Name in Openrow set in SQL query?

Allowing @ symbol in connection string for OPENROWSET from Synapse

Create ##temp table and insert the rows to an existing table only wherever the columns match

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

Getting A transport-level error when executing OPENROWSET

Filestream and using bulk insert via OPENROWSET gives File could not be opened. Operating system error code 50(The request is not supported.)

I am getting an error Incorrect syntax near &#39;OPENROWSET&#39;. while using openrowset function on dedicated SQL Pool

Executing an OPENROWSET on azure synapse result in a &#39;Resolving CosmosDB path has failed with error &#39;Secret is not base64 encoded.&#39;&#39;

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if &#39;yes&#39; then how?

How to allow all users to run this SQL query?

Can&#39;t access Excel file from Python and get error No such file or directory?

The OLE DB provider &quot;Microsoft.ACE.OLEDB.12.0&quot; has not been registered

Skip LAST Line with OPENROWSET

Openrowset but select only specific columns from file

Getting &quot;7302 - Cannot Create an instance of OLE DB&quot; Error after ACE/ODBC Driver update

I have an Excel file with a table and additional text (comments) on the same sheet. I want to extract ONLY the table. How can I do this in SQL?

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

I am getting an error Incorrect syntax near 'OPENROWSET'. while using openrowset function on dedicated SQL Pool

Executing an OPENROWSET on azure synapse result in a 'Resolving CosmosDB path has failed with error 'Secret is not base64 encoded.''

How can I use with inside apply in sql server? I know another solution without apply. but can we do with outer apply? if 'yes' then how?

Can't access Excel file from Python and get error No such file or directory?

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered

Getting "7302 - Cannot Create an instance of OLE DB" Error after ACE/ODBC Driver update