@rejipr1982: Hugo already mentioned this in his response. Still thanks to evaluate the same.

Toreador (1/4/2011)

---

WayneS (1/4/2011)

---

I think that it's upon the QotD authors to attempt to write their questions to apply to as many versions of sql as possible (obviously, when writing about...

cengland0 (1/4/2011)

---

Hugo Kornelis (1/4/2011)

---

I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and...

Hugo Kornelis (1/3/2011)

---

john.moreno (1/3/2011)

---

Which...

rejipr1982 (1/3/2011)

---

Thanks.

While working with this type of comma seperated string, first we need to split the string with the help of table valued function.

We can pass the comma deliminated string...

tsqlnewbie (1/2/2011)

---

hi i got a situation where i need to write a stored procedure to return result set to the front end

it should return results depending on the drop...

Nice question. I learn new concept today.

zahrahLand (12/30/2010)

---

Hi Guys

I do not work for Bookshop!!

what is the problem with you guy? :crying:

You are making fun of me :angry:

Thank you Craig for you explanation

🙂

I found another...

Whenever dealing with dynamic query, its good to first use PRINT command, execute the string captured by print command to check the desired result. If you are satisfied with the...

Profiler is not able to help you on it because it is not able to capture network related issue. You can view SQL Server error log.

Nice question.

Also, please check "DBCC CHECKDB" output. It checks the logical and physical integrity of all the objects in the specified database. you use the PHYSICAL_ONLY option for frequent use on...

Nice article Nakul. Thanks 🙂

Merry Christmas to all !!!

dbuendiab (12/23/2010)

---

It's a very disturbing behavior, and, looking the answers, those of you who complain has the issue addressed with the correct update, but I have seen a lot more...