Easier question with lot more information.

Hugo,

In this scenario, eventhough if we run both insert statements as single batch, first statement will be executed successfully and we will get error only on second one rite?...

Hugo Kornelis (5/18/2013)

---

sea4stars (5/18/2013)

---

Interesting: After I decided on my answer of the first insert running ok, and the second insert failing, I fired up my trusty copy of...

Earlier I'm aware of Index and constraints will not be transferred to destination table..but about Computed columns i came to know only from this QotD. Thanks kapil.

+1

Nice and interesting one..

Calibear (5/21/2013)

---

Thanks for all the tips. This is my first attempt at a Question of the Day, so I will definitely take all your suggestions into account (including pointing to...

Great question..

Good Information..

nenad-zivkovic (4/24/2013)

---

kapil_kk (4/23/2013)

---

Hi,

I was not aware of the fact that after making

SET IDENTITY_INSERT dbo.Test OFF;

identity value gets incremented. I am confused now as what is the purpose of...

Kapil good going...

Good chance to recall return types & Data type precedence of ISNULL,CONVERT & CASE...

Thanks for your reply Hugo.

Hugo Kornelis (4/19/2013)

By the way, it's very easy to check this kind of questions for yourself. Just copy the code in SSMS, make changes, and see...

Thanks Hugo..

If insert statement was within Explicit transaction then even first row will not be inserted and the result of final query will be 0. Am I right?

Whether XACT_ABORT...

Nice...

Thanks man.. You hit me...