What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / jeetu
Function can be used inside the queries but Store procedure never used inside the queries For Example Given below:
select avg(salary) from employee;// allowed here
avg(): is function
Select sp(salary) from employee // Not allowed here
sp(): is stored Procedure
Thanks
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by normalisation?
What is the difference between left and right outer join?
How to find index size for each index on table?
What is policy based management (pbm)? : sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Which are the two editions in which SQL Azure database available?
Explain microsoft sql server functions?
How to make conditional sum in ssrs?
When would you use a before or after trigger?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to enable tcp/ip protocol on a sql server?
How to replace given values with null using nullif()?
What is trace flag in sql server?
Why union all is faster than union?
Explain various data region available in ssrs with their use?