Question : I’m trying to figure out a way that I can pass a filename into a stored procedure that […]
Tag: openrowset
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 […]
Error when using OPENROWSET from a View as a nonsysadmin
Question : [SQL Server 2012] I am running into an issue regarding the usage of a non-sysadmin account calling a […]
What is the potential fallout of changing SQL Server’s log on account?
Question : I need to be able to read files from a UNC path in TSQL and am getting an […]