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
Do you know what is similarity and difference between truncate and delete in sql?
What is mscorsvw.exe - process - microsoft .net framework ngen?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Are semicolons required at the end of sql statements in sql server 2005?
What are indexes in sql?
How to add a new dsn with the odbc driver for sql server?
How many categories of functions based their return modes?
What are a scheduled jobs or what is a scheduled tasks?
How to find index size for each index on table?
What is user-defined functions? What are the types of user-defined functions that can be created?
How to execute a stored procedure in ms sql server?
State the difference between local and global temporary tables?
What are magic tables in sql server?
What is the difference between DATETIME2 and DATETIME?
What is query optimization process?