Nice and simple

Nice one...

http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Have never had an experience wif this but I took a guess that this shouldn't be a problem and I was right.

Tx learned 1 or 2 things & also did it wif a table variable and saw different results as well.

DECLARE@CategoryChanges TABLE

(

ChangeID int Primary Key Identity ,

CategoryID int ,...

Beaten but i learned 1 or 2 things

Already knew about this and tx

Nice one Scott.

Good one, didn't know that the ## is for the global temp object, I thought tat this was only for global temp tables...Good one though.

Happy 2010....!!!

Chris Carter-210078 (12/30/2009)

---

The complete answer should be “It depends”. If you have a case sensitive collation designator you will get:

Msg 208, Level 16, State 0, Line 3

Invalid object name...

I've got it...

I think you misunduerstood what the statement said but if you...

Got beaten but this was an eye opener for me. even though I went with #2 and #3 I am opting to do another test to show my argument.

But this was not because of the null reason...

I'd like to try the produst as it seems to be cool and Nice to have.