Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Userdefined function and
stored procedure? Explain and give the example also
- 5 Answers
- 10765 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
1. function always run with select command while stored
procedure execute with execute command
2. function not provide output parameter facility
while stored procedure provide output facility
3. function always execute means it execute more than one
time while store procedure execute only one time
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you test your database? : sql server database administration
How to use the inserted and deleted pseudo tables?
Mention the command used to rename the database.
What is Extended user-defined?
What happens if date-only values are provided as date and time literals?
What is @@rowcount in sql?
What is tabulation?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is the difference between resultset and resultsetmetadata?
What is a transaction and why is it important?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the requirements for sql server 2016?
What are the new features are introduced in sql server 2012 reporting services?
Does a full backup include transaction log?
What are partitioned views and distributed partitioned views?
