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 are the different types of Indexes available in SQL Server?
Sql server reporting services vs. Crystal reports.
Explain the different types of backups available in sql server? : sql server database administration
what are cursors? : Sql server database administration
Explain subquery and state its properties?
Explain system scalar functions?
Do you know what is fill factor and pad index?
What is snapshot parameter in ssrs?
What is the purpose of a table?
Explain a join?
How can we rewrite sub-queries into simple select statements or with joins?
What is data mart? : sql server analysis services, ssas
How to see existing views in ms sql server?
What are types of subqueries?
What is the ‘fillfactor’?