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

Scripts by William Talada

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

FileNameSplitter

Function to split a full file name into drive, path, file name, and extension.  Read more...
By William Talada 2013/07/03 | Source: SQLServerCentral.com | Category: filename
Rating: |  Discuss |   Briefcase | 781 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: SQLServerCentral.com | Category: uppercase
Rating: |  Discuss |   Briefcase | 913 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: SQLServerCentral.com | Category: isnumber
Rating: |  Discuss |   Briefcase | 701 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,728 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 | 814 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,085 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 | 751 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,523 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 | 1,000 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: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,413 reads
   Items 1 to 10 of 10