What does this do?

SELECT getdate()
WHERE getdate() > getdate()-1
OR getdate()-1...

Given type-compatible relations T1 and T2, which of...

Given type-compatible relations T1, T2, and T3, which...

Search for text in procedures (no cursors) UPDATE

This is an update to the Search for text in procedures (no cursors) function (excellent script), which lists all of the objects (searching in syscomments, so it excludes tables). I have added a 2nd column to the output of the object type.

In the following SQL query:


SELECT a, b, c
FROM...

SQL Server 2005 adds recursive queries as a...

CREATE TABLE #foo (col varchar(100))
GO
INSERT INTO #foo VALUES...

Given this:

DECLARE @BeginDate smalldatetime
DECLARE @EndDate smalldatetime
SET @BeginDate = '01/01/2005'
SET...

In SQL Server 2000, you have the following:

CREATE...

Correction to parsestring

The original function fails when a mistaken split char is being snet to the function.This can easly be corrected by adding an if to check the value of the @holdpos inside the loop before sending it to the substring functionif the value is 0 then break the loop