what is the difference between procedure and function.
Answer Posted / saurav kumar
1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.
2) Stored proedure may or may not return a value but
function must return a value.
3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is b tree index?
What is the order in which the sql query is executed?
What are indexers?
What is merge?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is the difference between dropping a database and taking a database offline?
What is the security principal at the server level that represents your session?
Differentiate between ms sql server reporting services vs crystal reports?
Describe in brief sql server monitoring ways.
List out the differences between the clustered index and non-clustered index in sql server?
What is etl - extraction, transformation, and loading?
Delete duplicate rows without using rowid.
What are the restrictions applicable while creating views? : SQL Server Architecture
State a few properties of relational databases?
What does it mean to be in union?