what is the difference between procedure and function.
Answer Posted / hitesh
1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I edit a procedure in sql server?
Show Practically Sql Server Views are updatable?
What is the use of custom fields in report?
How to execute the cursor queries with "open" statements?
What is the difference between update lock and exclusive lock?
What is nolock hint in sql server 2008
What are system databases into sql server (2005/2008)?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How we can refresh the view?
How can windows applications connect to sql servers via odbc?
How many types of the database links?
What is the maximum size of a dimension? : sql server analysis services, ssas
what are the critical issues you have resloved in your company
What is indexing in sql server with example?
What is merge?