Keeping the title as noise ; kool ...

stoplists; I wasn't sure of the nomenclature but I got that correct after reading an article ...

nice to learn something.

thanks for the question

nice question ..

Lokesh Vij (10/11/2012)

---

Thanks Sreenivas for the question. Indeed we discussed the situation of "Divide by zero error" in your earlier QOTD discussion forum "While Loop - 1".

All in all ending...

Eugene Elutin (10/11/2012)

---

Float is a very bad choice for monetary values as it's approximate numeric.

I would recommend Decimal which is precise (exact numeric).

You can use Money too, if you brave...

Lokesh Vij (10/10/2012)

---

I was hoping this too....Not every one got it correct!

Correct answers: 75% (9)

Incorrect...

khushbu (10/9/2012)

---

I have been hearing lately that SQL Server when performing update to any table, first deletes that set of records and then inserts the record with the new value.

Wonder...

Lokesh Vij (10/9/2012)

---

Initially I thought this division is the key to answer this question; as...

yes, nice question; try and catch doesn't hold anything.. even if you put the above code in a transaction it would still give 11.

well, instead of 10/0.00001 try using 10/0...

good question..

nice and easy ..

Thanks

Ya i faced the same issue while creating a one time script . Since it was meant for another team , so I just had it executed in 5000 records...

Just and example:

declare @var int = 40

DECLARE @XML XML='<ROOT>

<ITEMS PID="0" FN="DEFAULT " LN="DEFAULT" />

<ITEMS PID="1" FN="HARISH" LN="SINGH" />

</ROOT>'

SELECT @XML

SET @XML.modify(' ...

(Bob Brown) (10/5/2012)

---

bitbucket-25253 (10/5/2012)

---

Hugo Kornelis (10/5/2012)

---

If points are that important for you, you can have one of mine. Heck, you can have all of...

mccork (10/4/2012)

---

Lokesh Vij (10/4/2012)

---

sam.dahl (10/4/2012)

---

I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement...

Lokesh Vij (10/4/2012)

---

sam.dahl (10/4/2012)

---

I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that...

nice and easy ..

thanks for the question.