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 are views in ms sql server?

0 Answers  


What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,


What is update_statistics command?

0 Answers  


What is history table in sql server?

0 Answers  


employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  


How to find table changes in sql server?

0 Answers  


what is Full Text Search ?

1 Answers   TCS,


How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  


How to check status of stored procedure in sql server?

0 Answers  


What is 'write-ahead log' in sql server 2000 ?

0 Answers  


How to enable/disable indexes?

0 Answers  


define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,


Categories