SQLServerCentral - Scripts by William Talada

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