SQLServerCentral / Discuss Content Posted by Amin Sobati / Article Discussions / Article Discussions by Author

Row-By-Row Processing Without Cursor

Amin Sobati — Sun, 03 Dec 2006 19:02:00 GMT

Comments posted here are about the content posted at temp

Yaroslav Pentsarskyy-353753 — Wed, 16 Aug 2006 09:25:00 GMT

Comments posted to this topic are about the content posted at temp

Krishna Mohan Thamisetty — Wed, 23 Aug 2006 11:21:00 GMT

We can use Exists instead of Outer Join which is more speed than Outer Join

When you are not expecting any column from second table then don't use Join use only Exists. Like following

SELECT S.* FROM Students s WHERE NOT EXISTS ( SELECT 1 FROM StudentExam se WHERE se.ExamName = 'SQL Server' AND S.StID = SE.StID