Rupal Raval (1/5/2010)

---

what error does it throw?

have you written

'declare @tablevariable varchar(100)

set @tablevariable = 'any valid table name'

Before code C?

map @tablevariable to one of your database table, select that database...

OK, I answered C because A and B are so completely wrong that C is the only option where we can reasonably guess that the setter of the question got...

I agree with most of what's been said alreay, but I also believe that it's possible (although quite difficult) to be a good manager and a good technician at the...

Just one question: why does the question say use two separate instances of SSMS or QA, and not two separate windows in one instance? The behaviour should be...

I tend not to make calendar-based resolutions - after all, if I need to do something why should I wait until Jan 1 to do it?

Last year, having up until...

I agree with Steve - this is a fundamental security error. It is crazy to push products without this capability.

It isn't a panacea, but that's no reason not to...

I did the same -...

SeñorDBA (12/18/2009)

---

Although the dictionary term isn't defined in terms of the technology used, when you say "database" to any DBA, programmer, IT guy or enthusiast 99 times out of 100...

Not in any database...

Until you said that I was 100% with you.

But as a real mathematician (couple of degrees,...

Good article, and much interesting discussion.

The outfit I ran until the middle of last year will be going to SQLS 2008, despite it not being much different from 2005 -...

Steve Jones - Editor (12/17/2009)

---

I would agree that #2 is a little incomplete. That answer has been edited and points are being awarded back to everyone that has answered to...

Jeff Moden (12/21/2009)

---

There are certain fundamental "principles" to all great code... "touch" only the data that's absolutely necessary, execute only the code that needs to be executed, keep the code...

Julie Zeien (12/16/2009)

---

I apologize for the incorrect explanation. I ran into a problem with this sort of thing about 3 months ago, and I looked all over BOL EXCEPT...

Both approaches have advantages, both have drawbacks. Which is best depends on a lot of factorsd in the system you are building, and it may be that given your...