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

Scripts by Rich Yarger

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Identify Column Data Types

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.  Read more...
By Rich Yarger 2014/04/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,096 reads

Update 2 databases with 1 script

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.  Read more...
By Rich Yarger 2011/03/14 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 2,087 reads
   Items 1 to 2 of 2