Top "Openrowset" questions

OPENROWSET is a T-SQL function that can be used in Microsoft SQL Server to read remote data from an OLE DB data source.

how to use openrowset to execute a stored procedure with parameters

I'm creating a stored procedure which gets some parameters and in turn these parameters are sent to another stored procedure …

sql-server-2008 tsql stored-procedures openrowset
Convert scientific notation to float when using OpenRowSet to import a .CSV file

I am using openrowset to import a csv file into SQL Server. One of the columns in the csv file …

sql-server scientific-notation openrowset
OPENROWSET with Excel file

I want to execute simple statement: SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\Temp\;','SELECT * FROM […

sql-server sql-server-2008 excel oledb openrowset
Update to Openrowset SQL SERVER 2008

I'm trying to do an UPDATE action to a remote table from a local query. Obviously i know it should …

sql-server-2008 sql-update openrowset
Using OPENROWSET to dynamically retrieve SP results when SP contains # temp tables

My Scenario I'm working on a database which will contain many details from various Stored Procedures in different databases across …

sql sql-server tsql dynamic-sql openrowset
How to create and populate a table in a single step as part of a CSV import operation?

I am looking for a quick-and-dirty way to import CSV files into SQL Server without having to create the table …

sql-server sql-server-2000 bulkinsert create-table openrowset
T-SQL: issue with string concat

I have a set of audio files with names GreenLine1.mp3, GreenLine2.mp3 e.t.c. I'm going to write …

tsql sql-server-2008 string-concatenation openrowset
How to export SSIS to Microsoft Excel without additional software?

This question is long winded because I have been updating the question over a very long time trying to get …

excel ssis export openrowset
openrowset for excel: can we skip several rows?

I will use the following sql to read data from excel, but sometimes I need to skip first several rows. …

sql sql-server openrowset
XML parsing error: why is semicolon expected?

I'm a newbie struggling with trying to import XML from an external third-party into SQL Server. I tried this SQL …

sql-server xml openrowset