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 are the different Authentication modes in SQL Server and how can you change authentication mode?

644


What are the tables in sql?

629


What is hot add cpu in sql server 2008?

524


What is the difference between createstatement and preparedstatement?

494


How many servers can we create in a single subscription?

146






What are views in ms sql server?

600


what are the types of indexes? : Sql server database administration

598


Can we write ddl in trigger?

498


What is the use of commit?

546


Why is normalisation important?

500


Why use “pivot” in sql server?

629


What is transaction server implicit?

535


What happens if you delete a table that is used by a view?

568


What is the difference between varchar and varchar(max) datatypes?

563


how many bits ip address consist of? : Sql server database administration

464