Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by William Talada profile

   Items 1 to 11 of 11   

Show Table Parents

Which parent tables must contain rows before inserting in to TableX?  Read more...
By William Talada 2014/12/04 | Source: | Category: foreign key
Rating: |  Discuss |   Briefcase | 1,361 reads


Function to split a full file name into drive, path, file name, and extension.  Read more...
By William Talada 2013/07/03 | Source: | Category: filename
Rating: |  Discuss |   Briefcase | 828 reads

ASCII Character Groups in String

Powerful function to find strings containing or excluding classes of ASCII characters.  Read more...
By William Talada 2012/09/10 | Source: | Category: uppercase
Rating: |  Discuss |   Briefcase | 980 reads

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: | Category: isnumber
Rating: |  Discuss |   Briefcase | 722 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: | Category: select
Rating: |  Discuss |   Briefcase | 2,783 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 826 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: | Category: datetime
Rating: |  Discuss |   Briefcase | 1,128 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: | Category: deploying
Rating: |  Discuss |   Briefcase | 759 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: | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,583 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: | Category: administration
Rating: |  Discuss |   Briefcase | 1,013 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 2010/08/04 | Source: | Category: table
Rating: |  Discuss |   Briefcase | 1,437 reads
   Items 1 to 11 of 11