I don't want to come off as mean, but your problem is that you fail to communicate what your problem is.

If your object is in fact the Java "Date" class,...

Excellent question!

I got it wrong on the strength of some tests I ran that gave me the 'Column name or number of supplied values does not match table definition.' error....

SQL Server does...

Truly a good question because it provoked a lot of thought as to which techniques are possible, valid and practical.

I got it "right" (yay!), but after reading the discussion I...

This is not a particularly very well designed question. What is a comment and what is the definition? I would say the comments inside an object are part of the...

Great question.

But the version should have been specified. In SQL 2000 you can see the execution plan even for encrypted procs. Although that would probably have been a dead giveaway...

Good question!

I was pretty sure that the first create would fail since the operator ^ isn't described in BOL under arithmetic operators. It never occured to me that it could...

Oleg Netchaev (10/29/2010)

---

Oh well, I lost a precious point on this one. The statement in question

select @a =+ @b-2

looked so ridiculous that it made me think...

Carlo Romagnano (10/29/2010)

---

I think the question author CONFUSED himself with the syntax for compound operators,...

I realized there was probably a 50% risk of getting it wrong which I did. :crying:

Interestingly in BOL it wasn't specified whether assigning a new identifier with NEW_BROKER actually enabled...

Good question!

Maybe I shouldn't admit it, but Activity Monitor is something I had completely missed. DOH!

Hugo Kornelis (10/13/2010)

---

It is your client software that converts this to a character representation so that you can see it on your screen. The client software chooses to represent these...

MHilsher (9/24/2010)

---

Rune,

I've got some similar situations in a database that I'm working with and found that the alternative seems to be just as bad. We've created functions to get...

jeff.mason (9/24/2010)

---

As far as NULLs go, I have to say NULL is a good thing for some DATE columns. If you have, say, a StartDate and an EndDate column,...

sjimmo (9/24/2010)

---

I...