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
How do I view views in sql server?
Give an example of why you would want to denormalize a database
Do you know what is similarity and difference between truncate and delete in sql?
How many categories of data types used by sql server?
How can you ensure that the database and sql server based application perform well?
What is the difference RDBMS and Graph Database?
How to list all field names in the result set using mssql_field_name()?
What is difference statement and preparedstatement?
What are the operating modes in which database mirroring runs?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Does sql server 2000 full-text search support clustering?
What do you understand by hotfixes and patches in sql server?
How to find which stored procedure is currently running in sql server?
What is sql server used for?
What are the export options of ssrs?