Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is order of B+tree?

0 Answers   HCL,


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  


What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  


how to invoke a trigger on demand? : Sql server database administration

0 Answers  


What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,






Tell me the phases a transaction has to undergo?

0 Answers  


What happens if you delete a table that is used by a view?

0 Answers  


What is a data collection table?

0 Answers  


What is the difference between for xml raw and for xml auto?

0 Answers  


How do you read transaction logs

1 Answers  


Explain about merge replications?

0 Answers  


What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,


Categories