Hugo Kornelis (9/13/2012)

---

If you change the SSMS configuration to use NotGo as batch seperator, then the script supplied will contain two batches. In each of those batches, @test-2...

Sorry to be pedantic, but I feel I have to in this case.

GO, or NotGo, aside not one person can run this complete script without modification or error.

@test-2...

I do like these easy questions to start the week 😀

Good question, thanks.

What a fun question, thanks.

At first glance my instinct was to go with zero, but then I noticed it was a table variable.

Phew 😀

Good question, thanks.

Thanks for the easy 7 points Steve.

As you say Labor Day will mean additional physical labor around the house for most I would imagine. Happy Labor Day to all American...

IgorMi (8/31/2012)

---

Nice question!

It is good to know the advantages and disadvantages of temp tables and temp variable tables

The following code will work fine:

create table #tmp(SlNo int identity, Name varchar(200))

INSERT INTO...

Thanks for the great question Hugo, got the brain matter working. Had to answer by process of elimination and learned something new on the way. Excellent.

Cheers 😀

Today is a good day for an education.

Thanks for the great question, learned something new.

Thanks all for the great question and other interesting forum posts.

Makes a good read.

+1

Thanks for the good question.

It's been a good week for questions, and this has been a nice one to finish on.

Thanks for the question, and the point. 😀

Great question, thanks. I very quickly spotted the 1001 rows in the first statement, but wasn't sure if the other table types had different limits. Fortunately decided that the 1000...

Yay! I like these questions I can answer in the blink of an eye... now, back to work.

Thanks for today's question 😀

Perfect question for a Monday, than you very much.