I think the goal is to make it a set-based operation, so by SQL standard the error message should be as uninformative as possible ("String or binary data would be...

Thank you for exploring an approach that I hadn't considered. I actually advised a colleague this month that there isn't a practical way to send bulk rows to SQL...

Frankly, just asserting that CheckDB is a "comprehensive" database-validator had me reaching for No. One gotcha that I think I know is that after upgrade from SQL Server 2000...

And free onion rings.

GilaMonster (8/16/2009)

---

A simple example to show this is:

select * from sys.databases where name not in ('master','model')

select * from sys.databases where name not in ('master','model', null)

Note that this is only the...

Re this "traceflag" (I'm not familiar with using that term for "alter the data processing behaviour of the server", but clearly that's what you say): these posts and linked articles...

I will say that I for one wouldn't write 20 tips for better SQL without doing some research to make sure that all 20 were valid for all versions of...

Anyone can do th@. "create table [ ] (rja_carnegie@excite_dot_com int)" 😛 (on 2005)

I "depreciated" it myself, but if you're confident that a script only needs one variable...

A previous exercise elsewhere, which I think was about testing for primes in the fewest characters of script, was where I learned you can use @ as a variable name...

As for the editorial policy of the site, it's hard to argue with success. This is one of the most successful SQL sites anywhere. Obviously, it has something...

You don't, of course. Well, unless you set country code to...

Eddie Wuerch (8/10/2009)

---

Love it when folks incorrectly post about stuff that may be deprecated. After all that info is so hard to come by:

http://tinyurl.com/kr7tvb (lmgtfy link) ...

gregory.anderson (8/10/2009)

---

Grasshopper, by the way, I'm not putting them in master.....just using a dbname as an example (obviously a bad example).

Thanks for your response, but I'm having a little trouble...

If anyone would like to borrow my copy of Dilbert and the Way of the Weasel...

Co-workers and managers have company goals, steal-from-the-company goals, career goals, nepotism goals, not-do-any-work-after-lunch goals. ...

gregory.anderson (8/10/2009)

---

Here's a question about one of the items. You mentioned that writing "master.dbo.proc_name" is better than just "proc_name", well, what about writing "master..proc_name"? My company does not...