On SQL Server 2000, what will be the...

There is the data in the People table:

foo_id...

Cursors with SQL 2000 Part 1

This series of articles will examine the purposes, uses, and optimization of cursors in SQL 2000.

Utility proc for updating (sub) sequence columns

This is a utility proc that I use a lot for datawarehouse transformation/load processing. This is a generic proc for resequencing an integer column in sorted order within a given key combination.Note that 'key' is used here in a general context and not specific, that is there doesn't have to be any keys or indexes […]

SQL Server 2005 has a number of T-SQL...

Delete All

Here is a simpler version of the Delete All Script that was posted on 2004-10-07.Be careful it does what it is supposed to do delete all tables from the current database

You are using SQL Server 2000, and wish...

Count rows in all tables in a database

Quick way to counts rows in all tables in a database without using Count(*).

SQL SCRIPT to grant DBC_Execute to all user SP

SQL SCRIPT to grant DBC_Execute to all user defined Stored Procs.This SQL SCRIPT is handy specially after Stored Procs are DROPPED & CREATED; often users dont mention the SQL to grant DBC_Execute permission to the Store Procs.This SQL SCRIPT will grant execute permission to DBC_Execute for all user defined Stored Procs. The SCRIPT can be […]

Count elapsed business days between two dates

This is a UDF that counts the days between two dates ignoring weekends and corporate holidays (as supplied in a lookup table). This ignores the time component but could be adjusted should you need to. If both days are on the same work day then the elapsed days is considered 1. If started Monday and […]