Thanks Hugo for the information, very useful.

...one of the Batman movies. Don't recall which...

Yes, you are correct. What I was referring to was using named constraints such as explicitly naming the primary key on a temporary table.

create table #MyTemp (Column1...

peter-757102 (4/9/2010)

---

Cliff Jones (4/9/2010)

---

Also explicit naming of indexes and such on a temporary table will come around to bite you, glad you covered that. Very nice job on this...

I agree, great article and great discussion on this topic. I see developers get fooled into using a table variable over a temp table due to the fact that...

... lucky guess on my part.

I just need to finish my Time Machine so I can go back in time and choose the correct answer.

So given the following:

declare @a int

declare @b-2 varchar(2)

set @a = 10

set @b-2 = ' '

IF ISNUMERIC(@b) = 1

select @b-2 +@a + 2;

ELSE Print 'Unknown'

-- Even though the following...

Very interesting. I had no idea you could do that. Thanks.

Yes we do and very...

I would think that the Site Editor (Steve Jones) would play a role in the accuracy of the content?

I think the link http://msdn.microsoft.com/en-us/library/ms186289.aspx explains it very succinctly that 'Full database backups represent the database at the time the backup finished.'

This was a good question. And thanks Hugo for the explanation.

This is good information. Thanks for the question.

mark.pleasance (3/2/2010)

---

Hey Terry,

Please accept my apologies.

It's (was) a cut/paste of the script from a popular beer commercial meant to poke fun at Canadian culture.

(It's now affectionately called "The Molson Canadian...