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 system stored procedures?
What is the significance of null value and why should we avoid permitting null values?
What are the advantages of using stored procedures in sql server?
What is resource governor?
Describe triggers features and limitations?
What are sql server functions?
What are the benefits of normalization?
What will be the maximum number of index per table?
what is the information that can be stored inside a bit column? : Sql server database administration
How to find the version of sql server? : sql server database administration
How to create new table with "create table" statements?
What is sql injection and why is it a problem? : sql server security
How can we rewrite sub-queries into simple select statements or with joins?
Distinguish between nested subquery and correlated subquery?
State the difference between local and global temporary tables?