Answer Posted / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to create sub reports?
What are cursors in ms sql server?
How to create stored procedures with parameters in ms sql server?
Explain what are the authentication modes in sql server?
Explain the use of containers in ssis and also their types?
What is difference between index seek vs. Index scan?
How to list all stored procedures in the current database using ms sql server?
Explain active/passive and active/active cluster configurations?
What is the difference between a "where" clause and a "having" clause?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What stored by the master?
How to connect Azure federated root database and apply federation in entity framework?
Can two tables share a primary key?
What are the advantages of using stored procedures?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?