SQLServerCentral.com Articles tagged OPENROWSET

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

Wed, 21 Mar 2012 06:00:00 UT

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.

Loading XML Data into SQL Server (SQL Spackle)

Mon, 03 Jan 2011 07:00:00 UT

Learn how to load data in an XML file into a table in SQL Server.

Dynamic SQL execution on remote SQL Server using EXEC AT

Tue, 09 Jun 2009 06:00:00 UT

In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them.

Using the OPENROWSET function in SQL Server

Tue, 05 May 2009 06:00:00 UT

OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.

Using OpenRowSet - SQL School Video

Tue, 31 Mar 2009 06:00:00 UT

This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.

Using OPENROWSET to read large files into SQL Server

Mon, 29 Dec 2008 07:00:00 UT

OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.

Using SQL Servers OPENROWSET to break the rules

Thu, 14 Aug 2008 06:00:00 UT

Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?