Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: openrowset

how to temporarily change the sql server settings in order to do a task and when finished revert back?

By adminPosted on January 14, 2023

Question : when I run the script below all at once I get this error message: Msg 15281, Level 16, […]

Can OPENROWSET parameters be built dynamically?

By adminPosted on December 22, 2022

Question : This feels like an ‘obvious “yes” ‘ kind of question, but nevertheless: would it not be possible with […]

Dynamic file name for file import

By adminPosted on July 25, 2022

Question : I’m trying to figure out a way that I can pass a filename into a stored procedure that […]

Where do Linked Server Queries get executed?

By adminPosted on July 9, 2022

Question : I have two instances ServerA and ServerB, and I have created a linked server in ServerA for ServerB […]

OPENROWSET returns just one row

By adminPosted on February 3, 2022

Question : Im trying to import values from a .csv file which has only one column. I keep getting all […]

Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?

By adminPosted on November 12, 2021

Question : I have an example data file with following contents and saved with UTF8 encoding. oab~opqr öab~öpqr öab~öpqr The […]

SQL Server service permissions on network share depending on IntegratedSecurity=true/false

By adminPosted on August 27, 2021

Question : Our company receives a daily file from one of our customers. It is an EDIFACT file translated to […]

SQL Server : openrowset problem [closed]

By adminPosted on August 23, 2021

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

How to bulk insert data in vertical into sql server?

By adminPosted on June 15, 2021

Question : My data in below format. I have to insert into sql server table. agency NO booknbr 06000330 bookdttm […]

Using “Where clause” In OPENROWSET as variable

By adminPosted on May 4, 2021

Question : I need to have a where clause in OPENROWSET but it is not always fix. It might be […]

  • 1
  • 2
  • 3

Recent Posts

  • Help me define the tables in this scenario
  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding