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 is statement level trigger?
How to insert data into an existing table?
What do you understand by the data quality services in sql server?
What are Spatial data types in SQL Server 2008
How to loop through result set objects using odbc_fetch_row()?
How to create nested stored procedure?
What is difference between equi join and natural join?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How to verify the port number of the sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what happens on checkpoint? : Sql server database administration
How to create percentile function?
How to view existing indexes on an given table using sys.indexes?
How to manipulate data from one table to another table ?