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
- 10568 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
Explain the dirty pages?
How can you fetch alternate records from a table?
Is it possible in sql table to have more than one foreign key?
What is dml command?
What is command parameter in ssrs?
How do I know if localdb is running?
What is a cursor, index in sql?
Distinguish between nested subquery and correlated subquery?
What is the difference between lock, block and deadlock? : sql server database administration
Define tool Manage Statistics in SQL Server 2000 query ?
Sql server reporting services vs. Crystal reports.
Find columns used in stored procedure?
how you can list all the tables in a database?
What is the purpose of sql profiler in sql server? : sql server database administration
List few advantages of stored procedure.
