OPENROWSET is a T-SQL function that can be used in Microsoft SQL Server to read remote data from an OLE DB data source.
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 openrowsetI am using openrowset to import a csv file into SQL Server. One of the columns in the csv file …
sql-server scientific-notation openrowsetI 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 openrowsetI'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 openrowsetMy 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 openrowsetI 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 openrowsetI 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 openrowsetThis question is long winded because I have been updating the question over a very long time trying to get …
excel ssis export openrowsetI will use the following sql to read data from excel, but sometimes I need to skip first several rows. …
sql sql-server openrowsetI'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