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 […]

Last_Date_Of_Month

Get the Last date of the month for the given month and year In response to a post By: Anonymous - Posted: 2/16/2004 3:31:12 AM (Stored Procedure).... Thought that there should be a more efficient / functional way of doing this. And here it is. Of course, a function would probably be more efficient, and […]

E mail Validation

Script used to validate whether the given email address is valide or not.

Convert Character Data to Numeric

This is a simple stored procedure, for inclusion in your script writing efforts, that strips non-numeric data from a given varchar. This is most usefull in scripts used to clean-up data such as account numbers that may include spaces, dashes and the like.

Remove multiple whitespace from a string: revise

This is a re-written function that the idea got from yesterday's script. This function used a recursive call to simplify the script.

Your database includes the following two tables:

CREATE TABLE...