Sql Server: Does adding the condition in WHERE clause or JOIN clause matter?

Posted by Sqltimes
On December 14, 2013
0 Comments

Does it matter where you add a condition? WHERE clause or JOIN clause. How does it change in “INNER JOIN” or “OUTER JOIN”. Let’s take an example: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 CREATE TABLE dbo.LeftTable (ID INT) CREATE TABLE dbo.RightTable (ID […]

Posted by Sqltimes
On December 6, 2013
0 Comments

Something interesting I ran into a few days ago, were these new keywords (new to me) in Sql Server. SOME ANY ALL ALL is used several places so, its not all too new (ex: REBUILD INDEXES, GRANT ALL, etc), but SOME and ANY are particularly new and interesting. What is the purpose? Could it not […]

Sql Server: Does adding the condition in WHERE clause or JOIN clause matter?

Sql Server SOME ANY ALL keywords