Answer Posted / sakthi
Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is subquery? Explain the properties of a subquery?
do you know how to configure db2 side of the application? : Sql server database administration
How can I check that whether automatic statistic update is enabled or not?
How to rebuild the master database?
Can you index views?
Explain system functions or built-in functions? What are different types of system functions?
What is a scheduled job or what is a scheduled task?
Is it possible to have clustered index on separate drive from original table location?
How to enter binary string literals in ms sql server?
What kind of problems occurs if we do not implement proper locking strategy?
What are the kinds of subquery?
How to provide default values to function parameters?
What are the different subsets of sql?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
