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

Difference between Function and Procedure-in general?

Question Posted / arif

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

Please Help Members By Posting Answers For Below Questions

How many types of local tables are there in sql server?

919

Can group functions be mixed with non-group selection fields in ms sql server?

932

Explain the various types of concurrency problem?

1171

Explain transaction isolation levels in sql server?

1100

What program is used to store the data source file?

955

How secure is sql server database?

996

How to maintain a fill factor in existing indexes?

993

What is the difference between count and distinct count?

877

Where sql server user names and passwords are stored in sql server? : sql server database administration

1041

Tell me the phases a transaction has to undergo?

955

What are the character string functions supported by sql server 2005?

999

what exactly sql injuction.how to overcome.....

2531

What is a cube? : sql server analysis services, ssas

989

how can you check the level of fragmentation on a table? : Sql server administration

962

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1041