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

Explain full-text indexing?

What do you understand by hotfixes and patches in sql server?

when inserting to a table how many rows will be effected using triggers

how many types of store procedre in sqlserver 2000?

How to delete duplicate rows from table except one?

Give me any three differences between Truncate and Delete.

Can we use max in where clause?

What is the use of sql profiler in sql server 2012?

Can we call a function that has out parameter in select statement

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

What is repeatable read?

What is difference between process and thread? Explain lazy writer funcationality.

For more SQL Server Interview Questions Click Here