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
How to transfer data from a cursor to variables with a "fetch" statement?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain what is log shipping?
What are the drawbacks of reporting in ssrs?
What is schemabinding a view?
What is partition in sql server?
How do database indexes work?
What is normalization 1nf 2nf 3nf?
What are the different types of sub-queries?
Explain temporary table vs table variable by using cursor alternative?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain the Ways to improve the performance of a sql azure database?
Explain what is use of dbcc commands?
What is temporal table?
What is the difference between migration and upgradation in sql server?
