Difference between Function and Procedure-in general?
Answer Posted / sudhindra
A Function is always returns a value using the return
statement. A Procedure may return one or more values
through parameters or may not return at all.
| Is This Answer Correct ? | 28 Yes | 6 No |
Post New Answer View All Answers
How to add the custom code in Report?
What is a partition function in sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is collation sensitivity? Explain different types.
System variable and temporary variables
What is the difference between dbcc indexdefrag and dbcc reindex?
What are user-defined functions (udfs) in sql server?
What are the steps you will take to improve the performance of a poor performing query?
What is difference between drop truncate and delete?
What does it mean to normalize data?
Why use “nolock” in sql server?
What is difference between views and tables?
How do I find query history in sql server?
Which are the new data types introduced in sql server 2008?
Explain few examples of stored procedure over triggers?