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

Content with tag Reference Rss

   Items 1 to 5 of 5   
 

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,296 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,296 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,296 reads

'Just Google It'

A short editorial explaining the pitfalls of using search engines as reference for DBA's.  Read more...
By Bas de Zwart 2010/08/05 | Source: SQLServerCentral.com | Category: reference
Rating: |  Discuss |   Briefcase | 293 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2009/10/29 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 8,048 reads
   Items 1 to 5 of 5   
 
Tags
calculate (1)    
calendar (1)    
complex (1)    
data (1)    
date (1)    
delete (1)    
dimenson (1)    
domain (1)    
editorial (1)    
generate (1)    
google (1)    
insert (1)    
lookup (1)    
merge (1)    
migration (1)    
parameterization (1)    
populate (1)    
static (1)    
update (1)