Difference between Function and Stored Procedure?
- 9 Answers
- 18978 Views
- C1 India, NA, I also Faced
- E-Mail Answers
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 clustered index
Where do we use trace frag?
What are secondary xml indexes?
Why are sql functions used?
How can windows applications connect to sql servers via odbc?
What are policy management terms?
Why use identity in sql server?
How to add more data to the testing table in ms sql server?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Explain what is dbcc?
Explain syntax for viewing trigger?
How to create a new table in a given schema?
Explain what is lock escalation and what is its purpose?
How to rebuild master databse?
What does sql server mean?
