Hmm,
The regular expression below does not work for me.
Using Agent ransack there is a Test option. It doesn't work with the test
phrase:
INSERT INTO MY_TABLE_NAME WITH (NOLOCK)
Oh well.
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-Ne
thanks for all advice.
I will look into agent ransack, and agree its about time I tried Eclipse again
( it was my inability to use the search in the first place that stopped me
using).
cheers,
--~--~-~--~~~---~--~~
You received this message because you are sub
Hi,
Both searches return no results.
Do underscores in table names effect that pattern? eg MY_TABLE_NAME ?
>>> "Blair McKenzie" <[EMAIL PROTECTED]> 13/02/2007 2:10 pm >>>
Assuming your table names do not include spaces:
/INSERT INTO [^ ]* WITH (NOLOCK)/
If you have indenting etc in the sql t
Hi,
I need to look through my code for the INSERT INTO * WITH (NOLOCK) where the *
can be any table name.
Can anyone advise what the correct syntax may be?
ta,
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service