Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8944 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / hitesh
1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between cross join and full outer join?
How do I perform an unattended install of sql server 2000?
Explain four layers of abstraction microsoft architectured?
Write the SQL query to drop, truncate and delete table.
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to delete duplicate records based on single column from a table?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How to declare and use cursor variables?
How to create nested stored procedure?
What is a DBMS, query, SQL?
What is the full meaning of dml?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is isolation levels?
Explain user defined functions?
