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

What does the following return in QA results...

This is the data in the myWords table

RowID...

Script to return datetime as just date

You can return the date as a string (varchar) in whatever date format you like by adding a 'style' to the CONVERT statement. Exmaples of style values are (two left hand columns):1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 - dd […]