CELKO (12/30/2010)

---

Another short-circuit (or McCarthy) evaluation problem from Algol was functions with side effects:

IF a=b OR Boolean_function_with side_effect (x) THEN ..

If the function is skipped, then there was no side...

Thanks, Phil.

Excellent! Well done, Gus!

sknox (12/30/2010)

---

So under what circumstances can you short-circuit an XOR? (i.e, if either A or B but not both...

Thank you, Jon! It would have been a hill of crap without the help of Gus, Jeff and Paul (in strict chronological order).

Chris Morris-439714 (12/30/2010)

---

It's the financially-evocative tone of your avatar, Gianluca - he/she thinks you're loaded and modest...

Jack Corbett (12/29/2010)

---

Hey, did you know that SSC is now a dating site? Here's a PM I got from lord.god90:

Hello My New Friend.

Good Day and How are you today.

Please...

You're right, Paul (as usual ;-)).

From BOL:

GETDATE (Transact-SQL)

---

Note:

---

SYSDATETIME and SYSUTCDATETIME have more fractional seconds precision than GETDATE and GETUTCDATE. SYSDATETIMEOFFSET includes the system time zone offset. SYSDATETIME, SYSUTCDATETIME, and SYSDATETIMEOFFSET...

Toby Harman (12/29/2010)

---

Taking into consideration All the above posts, what about the 3rd option.

SYSDATETIME()

Advantages: Returns a DATETIME2

Disadvantages: ?

Personally, I prefer GETDATE() because there is also GETUTCDATE(). I don't believe there...

Both. In reverse order. :-):-D:-D

jcrawf02 (12/28/2010)

---

Maybe it's just me, but isn't this a solution in search of a problem? How often do the names of the months change? Just code the names in... (or...

You're welcome.

Glad I could help.

Have you tried with DAC?

eyejay (12/26/2010)

---

I can manipulate this field to get at just the date or just the time but I'm lost as to how to edit just the date component of this...

You can revert the value back to 0 (unlimited) connecting with DAC.

Here's a MSDN page that describes how to use the Dedicated Administrator Connection. Basically, you have to connect your...