Viewing 7 posts - 1 through 7 (of 7 total)
ScottPletcher (8/14/2013)
The code uses LIKE to compare the string, so just construct your string accordingly.<snip>
I'll add code to see the actual part(s) of the text that match if you want.</snip>
Yes,...
August 21, 2013 at 11:20 am
Thanks for the code! It works great if I know what I'm searching for, but unfortunately to be useful in my current situation it would have to return the actual...
August 14, 2013 at 11:56 am
Sorry for necro'ing an old thread, but I'm trying to do something similar. The difference is that I'm looking for multiple strings (matching a pattern) of varying lengths. I've tried...
August 5, 2013 at 12:38 pm
I had an older version of this script that I had inherited from my predecessor, stripped of any author information, and was just about to edit it so that it...
July 24, 2013 at 12:25 pm
Thanks for the assistance. I agree with your take on using a/b/c as aliases, but I was tasked with "get it working, don't get it pretty". I thought that replacing...
June 27, 2013 at 8:33 am
I'm having pretty much the same error...were you ever able to fix this?
February 9, 2011 at 9:03 pm
--minor changes so it works on a case-sensitive server
USE master
GO
BEGIN
IF LEFT(CAST(Serverproperty('ProductVersion') AS VARCHAR(1)),1) = '8'
begin
IF EXISTS (SELECT TOP 1 * FROM tempdb.dbo.sysobjects...
January 31, 2011 at 8:48 am
Viewing 7 posts - 1 through 7 (of 7 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy