Difference between Function and Stored Procedure?

Answer Posted / sumesh.tc

stored procedure is precompiled one but Function not( want
to compile each time)

Is This Answer Correct ?    20 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is query optimizer in sql server?

543


what are the critical issues you have resloved in your company

1550


What is tempdb in sql server?

510


What is difference between inner join and full join?

546


How to apply cascading referential integrity in place of triggers?

568






How to get a list of all tables with "sys.tables" view in ms sql server?

547


Which are the olap features?

546


How to return the date part only from a sql server datetime datatype?

571


What are sql server procedures?

541


What is the difference between nvl and nvl2?

549


What are the differences between decimal and float in ms sql server?

563


what is dbcc? : Sql server database administration

519


How to create a view on an existing table in ms sql server?

584


Define tool Manage Statistics in SQL Server 2000 query ?

524


How do I save a stored procedure in sql server?

493