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

Differentiate between SQL and ORACLE joins and write their syntax.

What is database normalization?

Does the unique constraint create an index?

Can we update data in a view?

What is the difference between varchar and varchar(max) datatypes?

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

About types of indexes in SQL server ?

What is oltp (online transaction processing)?

What is the default value of CHAR type?

Why main is user defined function?

How to connect sql server management studio express to sql server 2005 express?

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

For more SQL Server Interview Questions Click Here