What is the difference between Userdefined function and
stored procedure? Explain and give the example also
- 5 Answers
- 8927 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
Which are the two editions in which SQL Azure database available?
How to find the source of a table in sql server?
Can we return Data from 4(more than 1) tables in stored procedure?
How to provide login information for a new odbc dsn?
What is log cache in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
What are the dmvs?
What are the different index configurations a table can have?
What is RAID? What are the different types of RAID configurations?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is the size of transaction log file?
what are constraints? : Sql server database administration
What is row_number () and partition by in sql server?
What is create statement?
How to make a remote connection in a database?
