Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag OPENROWSET Rss

   Items 1 to 11 of 11   
 

XML Workshop : Utilizing Relational Data In XML Files

Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.  Read more...
By Matthew Pettit 2014/04/24 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,980 reads

SQL Server Dynamic XML Tag

Extract data from XML file from dynamic tag. in this below e.g we can add / remove Escalations tag from xml file. and depends on that result will display.  Read more...
Rating: |  Discuss |   Briefcase | 702 reads

Loading XML Data into SQL Server (SQL Spackle)

Learn how to load data in an XML file into a table in SQL Server.  Read more...
By Wayne Sheffield 2013/05/31 (first published: 2011/01/03) | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 19,595 reads

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

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.  Read more...
By Stan Kulp 2012/03/21 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,903 reads

Loading XML Data into SQL Server (SQL Spackle)

Learn how to load data in an XML file into a table in SQL Server.  Read more...
By Wayne Sheffield 2013/05/31 (first published: 2011/01/03) | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 19,595 reads

Dynamically generate Format File For OPENROWSET tekst file import

Dynamically generate XML format file for use with OPENROWSET or XML bulk insert.  Read more...
By Joey Moelands 2010/11/19 | Source: SQLServerCentral.com | Category: openrowset
Rating: |  Discuss |   Briefcase | 1,383 reads

Dynamic SQL execution on remote SQL Server using EXEC AT

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.  Read more...
By Additional Articles 2009/06/09 | Source: MSSQLTips.com | Category: openrowset
Rating: (not yet rated)  Rate this |   Briefcase | 4,308 reads

Using the OPENROWSET function in SQL Server

OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.  Read more...
By Additional Articles 2009/05/05 | Source: SearchSQLServer | Category: openrowset
Rating: (not yet rated)  Rate this |   Briefcase | 3,542 reads

Using OpenRowSet - SQL School Video

This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.  Read more...
By Andy Warren 2009/03/31 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 2,986 reads

Using OPENROWSET to read large files into SQL Server

OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.  Read more...
By Additional Articles 2008/12/29 | Source: MSSQLTips.com | Category: openrowset
Rating: (not yet rated)  Rate this |   Briefcase | 5,847 reads

Using SQL Servers OPENROWSET to break the rules

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?  Read more...
By Additional Articles 2008/08/14 | Source: MSSQLTips.com | Category: openrowset
Rating:  Rate this |   Briefcase | 4,022 reads
   Items 1 to 11 of 11   
 
Tags
xml (3)    
access (1)    
bcp (1)    
bulk import (1)    
bulk insert (1)    
c# (1)    
csv (1)    
dynamic sql (1)    
etl (1)    
extract, transform, load (etl) (1)    
format file (1)    
import files (1)    
integration services (ssis) (1)    
openquery (1)    
openxml (1)    
sql spackle (1)    
vb.net (1)    
video (1)    
xml file with dynamic tag (1)    
xslt (1)