3 days later the QotD is still incorrect - can this be corrected please?

Edit: Items in bold

There seems to be some confusion around what is happening here (or I misread some of the comments and the QotD answer?).

The data types of the columns...

Good question but the correct answer is "0 " (with 2 trailing spaces), not "0".#

Edit: Add example:

SELECT REPLACE(ISNULL ( CONVERT (char(3),1/9),'*'),' ','<Space>') AS Ret

The question has been updated after my response. The original version did not include the batch separators. The...

I like the question as it leads to some interesting observations 🙂

Upfront: The MSN article is for SQL Server 2000! Here is the link to the version for SQL Server...

ronmoses (3/1/2013)

---

Where I got tripped up was here, and I guess I'm still not sure I understand...

create proc sp1

as

select * from temp1

exec sp2

Without a BEGIN and END defining the body...

demonfox (2/28/2013)

---

tom.kane (2/28/2013)

---

I got tricked with this one. I said No, because the code will cause a syntax error as you can't mix creating tables and procs without using...

There is definitively no infinite loop as it throws an error when the max nest level has been reached.

Nice question, but the explanation lacks important information. Let me quote it for you here:

Table Hints (Transact-SQL) - SQL Server 2008 R2

---

WITH ( <table_hint> ) [ [ , ]...n...

I like the question. Thank you!

Wow, amazing question. Are you an MCQA (Microsoft Certified QotD Architect)?

Thanks for the question!

Lets drive this a little further:

CREATE TABLE dbo.Test(a INT NOT NULL, B INT NOT NULL)

INSERT dbo.Test (a,b) VALUES(1,2)

INSERT dbo.Test (a,b) VALUES(3,4)

GO

DECLARE @a INT = 100

...

bitbucket-25253 (1/29/2013)

---

Unfortunately the criticism touches me deeply, but I have learned to bite my tongue and say nothing that provokes further argument. I try to learn from the criticism...

Highly controversial question! 50% say yes, 50% say no!;-)