Difference between Function and Stored Procedure?
Answer Posted / raj..
The difference mejor between procedure and function is that
function must return value. that should be only single and
function can pass any no. parameter but come out only one
value only using return statement.
procedure can pass any parameter and came out any no. of
values there no any RETURN word.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are entities and relationships?
Explain sub-query?
Explain the cursor lock types?
What is SubQuery in SQL Server 2008
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is the purpose of update statistics and scope_identity() function?
What is the difference RDBMS and Graph Database?
What is the difference between ddl,dml and dcl commands?
Explain subquery and state its properties?
which table keeps the locking information? : Sql server administration
If user is owning any SQL Objects, can we drop that user
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
how to define testing of network layers? : Sql server database administration
What are the encryption mechanisms in sql server?
Differentiate between a having clause and a where clause.