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

Content with tag columns Rss

   Items 1 to 20 of 26    Older >>
 

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,030 reads

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: datatypes
Rating: |  Discuss |   Briefcase | 1,167 reads

Advanced Display Table and Column Info

A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.  Read more...
By Luis Chiriff 2014/01/03 | Source: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 1,639 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,488 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,288 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,030 reads

Get all fields names for all tables in SQL

Script to generate all column names and table names  Read more...
By Raymond Xie 2013/07/10 | Source: SQLServerCentral.com | Category: notes
Rating: |  Discuss |   Briefcase | 1,526 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,196 reads

Tables and rows listing

Simple script which create a list of all the tables and rows of the selected DB.  Read more...
By Claudio Tregambe 2013/02/11 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 1,011 reads

Search for String in all columns

Find all columns containing a string value across all tables and schemas.  Read more...
By Wes Henriksen 2012/11/07 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,680 reads

Table Search Based on the Column

To Find all the tables based on a particular column  Read more...
By Bhargav Sesham 2012/11/06 | Source: SQLServerCentral.com | Category: table search
Rating: |  Discuss |   Briefcase | 1,209 reads

Understanding Column Properties for a SQL Server Table

Designing a table can be a little complicated if you don’t have the correct knowledge of data types, relationships, and even column properties. In this tip, Brady Upton goes over the column properties and provides examples.   Read more...
By Additional Articles 2012/10/26 | Source: MSSQLTips.com | Category: columns
Rating: (not yet rated)  Rate this |   Briefcase | 4,124 reads

Generate alter datatype script for entire database

ntext, text, and image (Transact-SQL). This script will alter the data type from image to varbinary(max) which is very much required as the data type is out of support.  Read more...
By Venugopal Saride 2011/11/28 | Source: SQLServerCentral.com | Category: ntext
Rating: |  Discuss |   Briefcase | 834 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,030 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,488 reads

Object Explore

summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.  Read more...
By Robin van Schaik 2010/08/24 | Source: SQLServerCentral.com | Category: data exploration
Rating: |  Discuss |   Briefcase | 1,035 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,030 reads

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...
By Jesse Roberge 2009/10/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,375 reads

Display rows vertically

A script to view selects of fat rows vertically with columns in alpha order  Read more...
By Steve McRoberts 2009/10/05 | Source: SQLServerCentral.com | Category: select
Rating: |  Discuss |   Briefcase | 1,842 reads

Search for a Column in all databases

This Script can be used for searching a column in SQL server 2005  Read more...
By Sandesh Segu 2009/08/05 | Source: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 961 reads
   Items 1 to 20 of 26    Older >>
 
Tags
search (4)    
datatypes (3)    
tables (3)    
t-sql (3)    
administration (2)    
find (2)    
sql server 2005 (2)    
text (2)    
utility (2)    
::fn_listextendedproperty (1)    
alter (1)    
base 26 (1)    
change column (1)    
data (1)    
data exploration (1)    
database (1)    
dba (1)    
defaults (1)    
definition (1)    
excel (1)    
find foreign key using sql (1)    
image (1)    
information_schema (1)    
kurtosis (1)    
list (1)    
locate (1)    
maintenance and management (1)    
metadata (1)    
metrics (1)    
miscellaneous (1)    
notes (1)    
ntext (1)    
object (1)    
object name (1)    
object search (1)    
permissions (1)    
quartiles (1)    
queries (1)    
range (1)    
select (1)    
single column in whole database tables (1)    
skew (1)    
standard deviation (1)    
statistics (1)    
stored procedures (1)    
string (1)    
sys.columns (1)    
sys.systypes (1)    
sys.tables (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
table name (1)    
table search (1)    
triggers (1)    
unpivot (1)