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

Content with tag Execute Rss

   Items 1 to 2 of 2   
 

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,237 reads

Demonstration on how to pivot data using temp tables

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)  Read more...
By Chris Morton 2008/10/10 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 883 reads
   Items 1 to 2 of 2   
 
Tags
check constraint (1)    
create (1)    
dynamic sql (1)    
foreign keys (fk) (1)    
indexing (1)    
nested loop (1)    
parameters (1)    
pivot (1)    
primary key (pk) (1)    
report (1)    
stored procedures (1)    
table (1)    
temporary tables (1)    
t-sql (1)    
unique (1)    
xml (1)