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 by William Talada
SQLServerCentral.com profile
Items 1 to 8 of 8
IsNumber fails cast while IsBigInt passes cast
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
Read more...
By
William Talada
2010/06/11
|
Source:
SQLServerCentral.com
|
Category:
isnumber
Rating:
|
Discuss
|
Briefcase
|
667 reads
Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
Read more...
By
William Talada
2010/01/21
|
Source:
SQLServerCentral.com
|
Category:
select
Rating:
|
Discuss
|
Briefcase
|
2,582 reads
Implementing Most Recently Used Lookups
This script will adapt ordering of look-up lists by foreign key usage.
Read more...
By
William Talada
2010/01/18
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
779 reads
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
Read more...
By
William Talada
2010/01/20
|
Source:
SQLServerCentral.com
|
Category:
datetime
Rating:
|
Discuss
|
Briefcase
|
1,035 reads
Validate Deployed Databases by Version
Save all object definitions to a single stored procedure for easy validation
Read more...
By
William Talada
2010/01/14
|
Source:
SQLServerCentral.com
|
Category:
deploying
Rating:
|
Discuss
|
Briefcase
|
725 reads
Show Cascade Delete Tree
See indented tree of tables involved in foreign key cascade deletes.
Read more...
By
William Talada
2010/01/07
|
Source:
SQLServerCentral.com
|
Category:
foreign keys (fk)
Rating:
|
Discuss
|
Briefcase
|
1,346 reads
Exec scripts in a group of databases
Easily execute your scripts in a set of databases
Read more...
By
William Talada
2009/12/30
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
934 reads
Find botched constraints, idxs, fks
Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.
Read more...
By
William Talada
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
table
Rating:
|
Discuss
|
Briefcase
|
1,353 reads
Items 1 to 8 of 8
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.