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

Content with tag column Rss

   Items 1 to 3 of 3   
 

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,079 reads

Convert int to Excel column name

This script converts a numeric column index to an Excel column name (ex: AC)  Read more...
By Peter Diplaros 2013/11/07 | Source: SQLServerCentral.com | Category: excel
Rating: (not yet rated) |  Discuss |   Briefcase | 1,210 reads

Locate a column across databases

This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...
Rating: |  Discuss |   Briefcase | 1,165 reads
   Items 1 to 3 of 3   
 
Tags
base 26 (1)    
data types (1)    
database (1)    
excel (1)    
search (1)    
utility (1)