Good start of week.

Thanks for question.

🙂

Thanks for start my day with an easy question.

Still i found result as "Correct answers: 100%"

Nice question, keep it up my friend !!!

🙂

Easy question. keep it up 🙂

+1

🙂

Hugo Kornelis (4/9/2013)

---

Danny Ocean (4/9/2013)

---

BUT statement 6 (ID 4 & 5) execute successfully and inserted two rows in table. In this we are using UNION ALL.

How it's possible ? Anyone...

Friends, i have a question. I have made same changes in script and execute it. First have a look on script

--statement 1

CREATE TABLE temp

(

ID INT NOT NULL,

MyText varchar(max) NOT...

Hugo Kornelis (4/9/2013)

---

I'm glad I double and triple checked before replying; I almost fell for it. The glaring error in how the trigger code handles multi-row inserts is so staring...

kapil_kk (4/8/2013)

---

Same here Vinay, forget about the TEXT datatype part and...

I don't see the table definition carefully and choose incorrect option.:angry:

Any way Good question, keep it up; 🙂

+1 🙂

I just guess and got correct 2 out of 3.

:doze:

Thanks Hugo for last two lines.

🙂

kapil_kk (4/4/2013)

---

Hi all,

I also thinks that the options are not well written... Sorry for that 🙁 ..

My point of concern was to to throw light on different behaviors of AND...

baabhu (4/3/2013)

---

For me at least option b and option d looks pretty much similar.

option B.

Query 1 will return all rows of table 1 and Query 2 will return...

Good example. But rather than creating six different variables, i would like to create only one variable and use sp_executesql.

Anyway. Thanks for question.