rVadim (8/7/2012)

---

tommyh (8/6/2012)

---

So here i was thinking this was a rewrite of the question we had 2 questions ago, since this question had the varchar(50) on str4 which would have...

I don't blame him. I've decided I'll have to retain an attorney before I do another QotD. 🙂

Thanks,...

Thomas Abraham (8/3/2012)

---

I believe that Execute (@str1) is what you should use....

I believe that Execute (@str1) is what you should use. I note...

Picked my answer,...

1 instance of production database, 3 test databases - one full copy for each developer - taken as rotating snapshots of the production database.

mtassin (8/2/2012)

---

Thanks for making me think... I had to sit there and keep reminding myself how the datetime2 values would round and then tried to keep two mental counts (statement...

Thanks for submitting the question. But, my general reaction amounted to a yawn. Your focus on case made the question seem even less interesting. Also, if you use a screen...

(Bob Brown) (7/31/2012)

---

Easy question but I have to learn to read. I picked the one that it wouldn't work on not the 5 it would. I...

Jeff Moden (7/30/2012)

---

I was pretty sure of the answer but went to check just to be absolutely sure because I've never gotten close to the limit. It just absolutely...

Andre Ranieri (7/27/2012)

---

Is this question relevant to SQL 2012 or also SQL 2008 R2 and SQL 2005 as well? I couldn't find the related version info on BOL.

Just kidding folks....

ibar, thanks for something different. When I read all the answers, and gave some thought as to why you had posted this question, I selected the correct answer. As of...

Thanks for the interesting question. Once again, it's nice to see the newer site members getting involved in the QotD.

Thanks kranthi1.aprdc for the question. I see you are relatively new to the site. So good to see you jumping in with a QotD contribution. As others have suggested, this...

Thanks for the question Mark! I got the right answer for the wrong reason, so I benefited doubly from the question - got rid of bad data and replaced it...