What is difference between stored procedure and function?
Answer Posted / rakesh
mojor difference is
function must return a value but a
procedure may or may not return a value
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to locate and take substrings with charindex() and substring() functions?
what is a transaction and what are acid properties? : Sql server database administration
What is the difference between resultset and resultsetmetadata?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Explain throw statement in sql server 2008?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What are sql azure firewall rules?
How to bind a view to the schema of the underlying tables?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Can an entity have two primary keys?
What is sql azure database?
What is create command?
How to provide values to stored procedure parameters in ms sql server?
Explain linked server in sql?
List the types of recovery model available in sql server?