Answer Posted / satyanarayana
In order to provide a condition to the select statement
either by group by column or aggregate function
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why and when do stored procedure recompile?
Can you index views?
What is the difference between upgrade and migration in sql server?
How raid can influence database performance?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are wait types?
Equi join and non equi join is possible with sql server?
What are the different types of subquery?
What is a coalesce function?
What is acid mean in sql server?
How can you append an identity column to a temporary table?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What kind of problems occurs if we do not implement proper locking strategy?
