No, no, no. It's been deprecated :hehe:

(Nigel) Yep, yep, yep 🙂

This might be safer:

SELECT CONVERT(VARCHAR(30),GETDATE(),121) + ' ' + REVERSE(SUBSTRING(REVERSE( CONVERT(NVARCHAR(30),GETDATE(),0)),1,2))

(when date goes to 2 digit day)

Thank you for the reply, Lowell.

In the production environment, that (and probably those) extended procedure call(s) are not available (permission denied).

The fully qualified term is "query execution plan" and includes two parts (as mentioned by others). Mr. Jones used the "execution plan" part, the bulk of us arguing for a...

I'm voting with the majority here. Reentrant and reusable. Got to interpret the words the same way - question and explanation. There is a distinction between "query plan" and "execution...

I apologize for this lame solution, but you could insert all of the new records first, leaving the id append off of ItemURL column, then go back and append the...

O.K. Am I missing something? Where is Step 4?

(Oops. Found it!)

Well, since everyone else likes to do subtractions, I thought I'd contribute an addition only solution 😀 (if you don't count DATEDIFF as subtraction :-))

SELECT DATEDIFF(dd,@testdate,(DATEADD(m,1,@testdate)))

or maybe

UPDATE table SET dtField = NULL WHERE dtField = 0 Or dtField = '' ?

Is the 'point' column an integer or a decimal field? (I think we should all get an extra .5 point for the aggrevation :-P)

Argh! How does something this simple and wrong make it through. Did nobody actually run the code prior to posting the question?

Steve, oh Steve, Cleanup on isle 42. ...

In my best Alex Tribeck voice: "Ohhh, sorry Gail. The correct answer was 3." 😀

Not to belabor the subject, but if your naming convention (poor as it is) for triggers was something like "ITRIG", "DTRIG", "UTRIG" for each table, would the script for dropping...

Just a little off the main topic, but I found the enumeration script for table and views really helpful when trying to determine which objects had triggers associated with them....