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
- 10528 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil sharma
Userdefined function can used in select statement.
It must return a values but in store procedure it is
optional.
Store procedure can use using sqlparameter but in
userdefined function it is not used.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is store procedure?
What are the different types of locks in the database?
How do I view a stored procedure in sql server query?
How do I determine how many instances of sql server are installed on a computer?
What is a scheduled job or what is a scheduled task?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Is candidate a key?
Describe how to use the linked server?
Which is the main third-party tool used in sql server?
What is lock escalation and what is its purpose?
What is the use of for clause?
Explain the Ways to improve the performance of a sql azure database?
What is the difference between functions and stored procedures?
What is the purpose of self join?
How to modify an existing stored procedure in ms sql server?
