Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
columns
Search for
any
content tagged
columns
Add a script
Items 1 to 13 of 13
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
|
837 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,429 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,121 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
|
777 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,002 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,767 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
|
932 reads
Object Search
Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.
Read more...
By
Sean Smith
2011/10/19
|
Source:
SQLServerCentral.com
|
Category:
object
Rating:
|
Discuss
|
Briefcase
|
2,468 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
2011/03/31
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
7,085 reads
Find a Table's Metadata
Stored Procedure that returns table information
Read more...
By
Crosbie Christopher
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
1,278 reads
Finding all data types in user tables
A quick way to get a snapshot of what data types are being used in all user tables.
Read more...
By
Gaby Abed
2008/12/04
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
1,018 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,310 reads
Column Level Permissions
GRANT Column Level Permissions
Read more...
By
Mani Singh
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,518 reads
Items 1 to 13 of 13
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.