Interested to Buy Any Domain ? << Click Here >> for more details...
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
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the federation in sql azure?
Explain what is “asynchronous” communication in sql server service broker?
Tell me what are cursors and when they are useful?
What is cursor in ms sql server?
What is schemabinding a view?
Explain about local stored procedure?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to specify the collation for a character data type in ms sql server?
What is recompile sql server?
What is blocking?
What is store procedure? How do they work? When do you use?
What is collation sensitivity?
What do you mean by an execution plan? How would you view it?
What does REVERT do in SQL Server 2005?
