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
- 10394 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 shared lock?
Name some of the open source software that you can use in alternative to SSR?
what is a transaction and what are acid properties? : Sql server database administration
What are translations and its use? : sql server analysis services, ssas
Why Master database is required?
How to execute the cursor queries with "open" statements?
How can I get data from a database on another server?
Explain the properties of subqueries in sql server?
how will add additional conditions in sql?
What is merge replication?
What is trigger and different types of Triggers?
Where can you add custom error messages to sql server?
Describe in brief sql server monitoring ways.
What is tcl in sql server?
Define model database?
