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


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

Post New Answer

More SQL Server Interview Questions

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,


How to create a new table in a given schema?

0 Answers  


Why people hate cursor?

0 Answers  


Delete duplicate rows without using rowid.

0 Answers   Nagarro,


How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,






What are synonyms?

0 Answers  


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  


when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,


What are the mathematical functions supported by sql server 2005?

0 Answers  


What is a collation in ms sql server?

0 Answers  


What extended events?

0 Answers  


in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  


Categories