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

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  


Do you know what is rank function?

0 Answers  


What are the advantages of log shipping?

0 Answers  


How to loop through returning rows?

0 Answers  


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  


What is the openxml statement in sql server?

0 Answers  


What are the different type of replication in sql server?

0 Answers  


What do you mean by sql server 2005 express management tools?

0 Answers  


Describe triggers features and limitations?

0 Answers  


Explain syntax for viewing, dropping and disabling triggers?

0 Answers  


How many ways to create table-valued functions?

0 Answers  


Explain the properties of sub-query in sql server?

0 Answers  


Categories