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

Content with tag rows Rss

   Items 1 to 2 of 2   
 

Fun with OVER

By Barry McConnell 2014/06/26 | Category: over
Rating: (not yet rated) |  Discuss |   Briefcase | 1,909 reads

Generate row constructors for existing data

Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard  Read more...
By Gabe Tower 2013/11/14 | Source: SQLServerCentral.com | Category: rows
Rating: |  Discuss |   Briefcase | 1,099 reads
   Items 1 to 2 of 2   
 
Tags
copy (1)    
dml (1)    
export (1)    
framing (1)    
import (1)    
inserts (1)    
integration services (ssis) (1)    
move data (1)    
over (1)    
range (1)    
row constructors (1)