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

How do I create a trace in sql server?

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

What is the purpose of UPDATE STATISTICS?

What does ss stand for sexually?

Define self join in sql server joins?

What are the default system databases in sql server 2000?

Do you know how to make remote connection in database?

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

How do you debug a procedure in sql server?

What is logshipping and its purpose?

What should we do to copy the tables, schema and views from one SQL Server to another?

What are .mdf files?

For more SQL Server Interview Questions Click Here