What are the pros and cons of putting a scalar function in a queries select list

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

Question Posted / maheswari

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

More SQL Server Interview Questions

What is the main purpose of having conversation group?

What is difference between view and materialized view?

Different Types of Functions ?

Is foreign key a primary key?

Explain temporary table vs table variable by using cursor alternative?

What is mapping schema?

Why union all is faster than union?

What is dataset and its uses

Are null values the same as that of zero or a blank space?

Define Check points and End Points?

How to use group functions in the select clause in ms sql server?

Can we shrink data file in sql server?

For more SQL Server Interview Questions Click Here