Is there any performance difference between if exists (select null from table) a

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

Question Posted / shtakshi bhatnagar

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

More SQL Server Interview Questions

If i am handling 150 servers then how to check the active jobs of all the servers?

What are the types of joins in sql?

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

How to download and install microsoft .net framework version 2.0?

How many types of triggers are there?

How is a full-text index updated?

What are window functions in sql server?

What is the difference between coalesce() & isnull()?

How to find out name of all employees who has salary less than 200 Rs.?

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

What are points to remember while using the fillfactor argument?

What is dml command?

For more SQL Server Interview Questions Click Here