I don't answer...

dwain.c (11/29/2012)

---

So how about an example?

I'd love...

This works, of course, but it doesn't address the requirement in the first post.

Meow Now (11/26/2012)

---

The oddity that I find interesting about this question is the fact that the UNION automatically sorts the results. In my head I'm thinking the results would...

Lokesh Vij (11/26/2012)

---

One more way without using EXCEPT or INTERSECT

SELECT Isnull(a.id, b.id)

FROM t1 a

FULL OUTER JOIN t2 b

...

I like this way of expressing the solution:

SELECT t1.ID FROM dbo.T1 AS t1

UNION

SELECT t2.ID FROM dbo.T2 AS t2

EXCEPT

SELECT t1.ID FROM dbo.T1 AS t1

INTERSECT

SELECT t2.ID FROM dbo.T2 AS t2;

Steve Jones - SSC Editor (11/1/2012)

---

Interesting discussion. Freedman does mention inserts and deletes, but he never wrote on the subject. Perhaps he was mistaken, perhaps he hasn't had time. The...

derek.colley (11/1/2012)

---

I'm afraid this question was just too obscure for me. It's a good question, sure, but why would I need to know this or reference it in any...

Interesting question, shame about the explanation.

GilaMonster (10/31/2012)

---

No, the Halloween problem is exclusively for updates. You can't insert or...

If Microsoft ever decide to replace the T-SQL parser with a human, they won't choose me.

Yes it is integer.

USE tempdb;

SELECT NULL AS n INTO #z

EXEC sys.sp_columns

@table_name = N'#z',

...

I found this a good and quite straightforward question (though it is SQL Server 2012 not SQL Server 2011).

Not NoiseList then? 😉

Hugo Kornelis (10/15/2012)

---

At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out...