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
- 10527 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
What is page in sql server?
We need to perform what steps in the following order to work with a cursor?
What is shared lock?
Explain what is it unwise to create wide clustered index keys?
What are sql server functions?
What is normalization? Describe its different types.
What do you understand by a stored procedure?
How to get the definition of a stored procedure back?
What is extended stored procedures?
Explain why variables called the most powerful component of ssis?
What is an etl file?
What does normalization do to data?
Define the one-to-one relationship while designing tables.
How adventureworkslt tables are related?
Explain what is lock escalation and what is its purpose?
