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 3 of 3   
 

EXECUTE

By Steve Knox 2014/12/09 | Category: execute
Rating: (not yet rated) |  Discuss |   Briefcase | 1,503 reads

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,248 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 | 903 reads
   Items 1 to 3 of 3   
 
Tags
dynamic sql (2)    
stored procedures (2)    
t-sql (2)    
check constraint (1)    
create (1)    
foreign keys (fk) (1)    
indexing (1)    
nested loop (1)    
parameters (1)    
pivot (1)    
primary key (pk) (1)    
report (1)    
table (1)    
temporary tables (1)    
unique (1)    
xml (1)