Nope. Catch just gets the last one.

Try Catch is more meant to capture runtime issues with data or security/access.

Red Gate has some tools that can help with that. Things like their data generator and Compare.

Brandie Tarvin (3/22/2011)

---

<groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's a bad...

I've worked in one place where there was definitely an adversarial relationship between the developers in IT and the rest of the business. In that case, it was due...

You can do that with a CTE and Row_Number pretty easily.

;with CTE as

(select row_number() over (partition by serialnr order by scantime desc) as Row

from dbo.MyTable)

delete top...

Well, the first thing to check would be the table design. There are designs that help with multiple, concurrent inserts, and designs that cripple them. The most important...

What you're looking at is multi-step authentication. Wince, grit your teeth, and do an online search for "kerberos". You can also search for "NT AUTHORITY/ANONYMOUS LOGIN", and you'll...

GilaMonster (3/21/2011)

---

Second request, seeing as I seem to have scared people away

I'm looking for a couple (and I do mean 2) editors for a non-SSC piece on page restores. Please...

SELECT DATEADD(DAY, DATEDIFF(day, 0, GETDATE()), 0)

Just put your date column in there where it has getdate.

WayneS (3/21/2011)

---

It looks like there's quite a few of us jumping into this twitter thing all at once....

select *

from MyTable

where MyDateColumn >= '3/15/11' and MyDateColumn < '3/16/11';

That's the basic idea.

If the date is a parameter or variable, you can use DateAdd to add 1 day to it...

Changing to Read Only creates a database level lock, and that can cause lock resolution issues till it finishes completing any existing transactions. I suspect that the change is...

To answer a few questions you posed specifically for me:

Your coming from the other side. Im new to this and the tools can help find and resolve problems quicker! Then...

Jeff Moden (3/19/2011)

---

But that's no reason to not use a function for something not included or even contrary to established documentation especially if it greatly simplifies the resolution to a...

You can use an XQuery statement in a join, or a Where clause, but not in that manner. If you try, you'll get an error about "exist" needing a...