What if you use a TRY/CATCH block?

BEGIN TRY

BEGIN TRANSACTION;

<DO STUFF >

COMMIT TRANSACTION;

END TRY

BEGIN CATCH

ROLLBACK TRANSACTION;

<...

Damn, I knew that the output params were not being used and returned by the procedure.

Still I was too fast to click the wrong answer. :blush:

But TOP(1) with no ORDER...

Thanks for the comments, Hugo.

I will keep that in mind. 🙂

We have a lot denormalized tables with 100+ columns and it's a major pain to maintain their DML.

Best regards,

Hugo Kornelis (11/29/2011)

---

INSERT INTO #ATable

(col1, col2, ...

Thank you for the question but I guess that's straightforward.

The "AS colX" parts of the SELECT statement are aliases to the columns returned by the SELECT statement and they don't...

Just one small correction: ALLOW_SNAPSHOT_ISOLATION is not needed for Change Tracking but it's the probably the safer way to use it with.

Best regards,

Excelent article, Roy.

I'm thinking that one of the ideal business solutions to use CT is for database synchronization from mobile devices or off-site databases.

To help CT become more "auditable", maybe...

Thank you for the additional info, Paul and Tom.

Best regards,

You can't do it while creating a view.

You could use the select inside a stored procedure and it would work at the creation time.

The call to the procedure will still...

michael.kaufmann (11/23/2011)

---

In case anyone gets stuck at the conversion table (which indicates implicit conversion between character and numeric data types), keep on reading to find this little comment towards the...

Dev @ +91 973 913 6683 (11/9/2011)

---

I am not convinced. Intellisense helps developers to write SQL code in SSMS with ease. It’s IDE feature. It should not affect your query...

Every vice is only an exaggeration of a necessary and virtuous function. ~Ralph Waldo Emerson

While I agree that foul language don't belong in technical articles (which is what the...

GilaMonster (11/9/2011)

---

In full and bulk-logged recovery the only thing that marks a VLF as inactive is a log backup.

Imagine, if a transaction roll back did mark a VLF inactive, what...

Hi, Gail.

That's an excellent article. Surely a result of years of experience.

Can I add a little related question to this topic?

Article (11/9/2011)

---

(...) Log backups are the one that most people...

Thomas Abraham (11/9/2011)

---

Same here, including the part wrong. Forgot that primary key generates an index implicitly. Doh. Partial credit? 🙂

Reminds me of my college days, when students would beg for...