October 12, 2015 at 11:16 pm
This was removed by the editor as SPAM
October 13, 2015 at 2:28 am
Prety easy question, a part of set theory (t1 n t2 n t3).
Thanks
October 13, 2015 at 2:36 am
The correct answer is that an error is returned as the columns are defined as "Id" and referenced as "ID" 😉
October 13, 2015 at 3:18 am
Toreador (10/13/2015)
The correct answer is that an error is returned as the columns are defined as "Id" and referenced as "ID" 😉
Toreador!
Default collation is case insensitive.
😀
October 13, 2015 at 4:58 am
Nice question, thanks. It's also a very efficient approach.
October 13, 2015 at 9:26 am
Very nice question. I hadn't had the chance to use this function yet and the question code was a quick way to play with it and add it to my toolbox.
October 13, 2015 at 11:52 am
Good demonstration. Too many folks don't realize that an INTERSECT is essentially like an INNER JOIN (or rather it's the other way around!).
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
October 13, 2015 at 1:50 pm
Interesting one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2015 at 11:31 am
Awesome, thanks for the question, I learned something from this:
I didn't realize you could DROP multiple tables with a single DROP statement (DROP TABLE #t1,#t2,#t3);
😉
Rich
October 14, 2015 at 2:00 pm
It is wrong to say that the answer is - nothing. It is also wrong to say, that a table is blank. It is - an empty table! Every select-statement returns a table, but the table can be empty. You will always get the column-names!
October 16, 2015 at 7:33 am
Nice question, Satish, thanks. It's good to know about INTERSECT; it's like an inner join, but with all of the columns automatically put into invisible ON clauses:
SELECT A.ID
FROM A
INNER JOIN B ON A.ID=B.ID
INNER JOIN C ON B.ID=C.ID
It's pretty simple with just one column, but with multiple columns, the equivalent ON clauses would get pretty long.
October 21, 2015 at 7:25 am
Almost got caught off guard with the blank third table.
October 31, 2015 at 2:53 pm
Aaron N. Cutshall (10/13/2015)
Good demonstration.
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply