Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Adding more condition while joining or in where

Author  Topic  svjith Starting Member 5 Posts Posted - 2011-07-28 : 00:47:50 SELECT C.* FROM Content C INNER JOIN ContentPack CP ON C.ContentPackId = CP.ContentPackId AND CP.DomainId = @DomainId ...and: SELECT C.* FROM Content C INNER JOIN ContentPack CP ON C.ContentPackId = CP.ContentPackId WHERE CP.DomainId = @DomainId Is there any performance difference between this 2 queries?