<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
columns
Items 1 to 18 of 18
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
|
812 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,398 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,113 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
|
3,918 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
|
776 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,466 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,076 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
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,466 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,305 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,758 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
|
931 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,466 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,466 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,076 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,014 reads
Find a Table's Metadata
Stored Procedure that returns table information
Read more...
By
Crosbie Christopher
2013/05/21
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
1,276 reads
Column Level Permissions
GRANT Column Level Permissions
Read more...
By
Mani Singh
2013/05/21
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,507 reads
Items 1 to 18 of 18
Tags
search
(3)
tables
(3)
t-sql
(3)
administration
(2)
find
(2)
sql server 2005
(2)
text
(2)
::fn_listextendedproperty
(1)
alter
(1)
change column
(1)
data
(1)
data exploration
(1)
data type
(1)
data types
(1)
dba
(1)
definition
(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)
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 search
(1)
unpivot
(1)
utility
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
