Question : when I run the script below all at once I get this error message: Msg 15281, Level 16, […]
Tag: openrowset
Can OPENROWSET parameters be built dynamically?
Question : This feels like an ‘obvious “yes” ‘ kind of question, but nevertheless: would it not be possible with […]
Dynamic file name for file import
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?
Question : I have two instances ServerA and ServerB, and I have created a linked server in ServerA for ServerB […]
OPENROWSET returns just one row
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?
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
Question : Our company receives a daily file from one of our customers. It is an EDIFACT file translated to […]
SQL Server : openrowset problem [closed]
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?
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
Question : I need to have a where clause in OPENROWSET but it is not always fix. It might be […]