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

How to rebuild indexes with alter index ... Rebuild?

590


How do you rename a table in sql server?

490


What is transact-sql language?

574


How to define the name and server for a new dsn?

549


What happens when the SQL Azure database reaches Max Size?

90






Are null values the same as that of zero or a blank space?

578


What happens if date-only values are provided as date and time literals?

545


What's new in sql management studio for sql server? : sql server management studio

580


What is the purpose of forms?

497


How to create an multi-statement table-valued function?

530


Where are sql server usernames and passwords stored in the sql server?

613


Can multiple columns be used in sql group by clause in ms sql server?

548


List down some advantages of sql stored procedure?

559


Explain indexed views?

559


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1425