Viewing 15 posts - 31 through 45 (of 104 total)
jjturner (4/5/2013)
Although it does look like there's no way around firing...
April 5, 2013 at 12:31 pm
jjturner (4/5/2013)
Now I have another poser for you or anyone else...
April 5, 2013 at 12:08 pm
I once created a function that predicted the gender of a person by doing a lookup based on their name.
April 1, 2013 at 6:21 am
Lynn Pettis (3/29/2013)
March 29, 2013 at 3:35 pm
Hmmm...
So in the DateCategory table, add a column that defines if the specific date category (Project Review, Weekly Check-In, Project Handover, etc.) is 'limited' (?) and then have the function...
March 29, 2013 at 1:13 pm
Well dang it! I forgot that the whole reason for this is because sometimes they'll take a system generated numeric reference number and create their own using letters as in...
January 16, 2013 at 6:56 am
It does place anything starting with a letter at the end which is consistent with another application that we have. I don't think that I specified that requirement. From what...
January 15, 2013 at 7:56 pm
Well that was was simple enough. Now if anyone can recommend some really good antipsychotics that dissolve quickly in coffee...
http://www.dbforums.com/microsoft-sql-server/1174759-sort-numerically-alphanumeric-column.html
January 15, 2013 at 4:45 pm
Sean Lange (8/30/2012)
david.holley (8/30/2012)
BEGIN TRAN
UPDATE
IF @@ERROR <> 0 GOTO ERR_HANDLER
DELETE
IF @@ERROR <> 0 GOTO ERR_HANDLER
DESTROY WORLD
IF @@ERROR...
September 2, 2012 at 2:13 pm
So basically a single transaction and then check @@Error after each statement as in...
BEGIN TRAN
UPDATE
IF @@ERROR <> 0 GOTO ERR_HANDLER
DELETE
IF @@ERROR <> 0 GOTO ERR_HANDLER
DESTROY WORLD
IF @@ERROR <> 0 GOTO...
August 30, 2012 at 1:16 pm
OK, well now I'm a fan for SQLSearch by Redgate.
August 16, 2012 at 6:12 am
Jeffrey Williams 3188 (8/15/2012)
I would cheat...and download SQL Search from Redgate and let that utility do the searching for me. :w00t:
Dear Younger Self 10 minutes ago, Don't do...
August 15, 2012 at 2:37 pm
SQLKnowItAll (8/15/2012)
And this?
SELECT DISTINCT so.nameFROM sys.objects SO (NOLOCK)
INNER JOIN sys.sql_modules SC (NOLOCK) on SO.object_Id = SC.object_id
AND SO.Type = 'V'--P for stored procs
AND SC.definition LIKE '%textSearch%'
ORDER BY SO.Name
That's looking good.
Now, can...
August 15, 2012 at 2:07 pm
I ran it as is and didn't get any results. I then ran it leaving only the WHERE 1=1 which returned pretty much all the tables, but ColumnName is showing...
August 15, 2012 at 1:37 pm
"The first thing we do - kill all the users." - Shakespear (Henry VI Part 2 Act 4, scene 4)
August 15, 2012 at 12:58 pm
Viewing 15 posts - 31 through 45 (of 104 total)