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
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Difference between LEN() and DATALENGTH() in sql server ?
What happens to a statement batch if there is a compilation error?
What are the different index configurations a table can have?
What are window functions in sql server?
What are the different authentication modes in sql server?
What are the requirements to use odbc connections in php scripts?
How to create an index on a view?
What is 2nf example?
What are the differences between local and global temporary tables?
Can we use where and having clause together?
How to view existing indexes on an given table using sys.indexes?
How to sort query output in descending order in ms sql server?
Do you know what is openxml in sql server?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?