Difference between Function and Procedure-in general?

Answer Posted / arif

function can not have update,delete or insert statement but
Stored procedure can have

Is This Answer Correct ?    15 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is nolock?

750


Explain raiserror in sql server?

763


How to enter date and time literals in ms sql server?

687


what's the difference between delete table and truncate table commands? : Sql server database administration

682


Define Business Edition in SQL Azure?

98


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

724


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

768


Explain in brief how sql server enhances scalability of the database system?

702


How do I clean up sql server transaction log?

748


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1727


Define self join in sql server joins?

709


How to delete duplicate rows from table except one?

721


How to drop existing views from a database in ms sql server?

749


Sql server reporting services vs. Crystal reports.

112


what's the maximum size of a row? : Sql server database administration

744