What is difference between stored procedure and function?

Answer Posted / g.ashok

Stored Procedure need not to return a value.
Function should return a value.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is temporary table in sql server? Why we use temp table?

510


Explain difference between control flow and data flow?

522


New concepts of sql server 2005 use in your project.

1905


Explain the Ways to improve the performance of a sql azure database?

64


Explain user defined functions?

610






Define Business Edition in SQL Azure?

88


How do you handle datasets larger than 50 gb?

140


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

498


What is report rendering ?

102


application server is slow what may be the problem

1777


whats new about truncate in sql server 2008?

2020


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?

645


Give the query of getting last two records from the table in SQL SERVER?

535


What is the difference between substr and charindex in the sql server?

498


Does any body please help me what question's have asked for SSRS in the interview?

1662