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
How to deploy the Report?
What are the differences between local and global temporary tables?
How to find the service pack installed? : sql server database administration
Can you explain what is sql server english query?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How many types of the database links?
what are the different stages of Report Processing?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What are the basic features of a trigger in ms sql server?
Explain insert into select statement?
Can you leave a union at any time?
What is function of ROLLUP ?
Does sql server use java?
What is normalization? Explain different forms of normalization?
How many partitions a clustered index has by default in sql server 2012?