SQLServerCentral - Scripts by William Talada

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 | 812 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 | 686 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,646 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 | 802 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,056 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 | 741 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,439 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 | 982 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,379 reads