Difference between Function and Stored Procedure?
Answer Posted / sreyasmn
1. Function must returned a value,but stored procedure is
not necessorly returned value
2. A function can be used to calculations,but sp used to
solve a business logic
| Is This Answer Correct ? | 36 Yes | 3 No |
Post New Answer View All Answers
What is mean by candidate key?
What is the difference between update lock and exclusive lock?
Is there any difference between primary key and unique with the not null condition?
What are the source of constraints?
What is the recursive stored procedure in sql server?
How do database indexes work?
Explain steps of normalization?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is xdr?
Explain what you mean by 3 tier architecture.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
what's the difference between a primary key and a unique key? : Sql server database administration
What are the three different part of rdl file explain them?
Can You Use Data Mining Models In Ssrs?
What is the difference RDBMS and Graph Database?