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

What is the use of nvl work?

947

What is difference between sql and sql server?

937

What do you mean by cardinality?

848

What is a partitioned view?

949

What is a linked server in sql server?

1015

Explain what is row_number function?

972

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

1039

How would you use user_constraints table in DB?

939

Which database stores information about replication?

989

How to select true false based on column value in sql server?

953

What number aggregate functions are accessible there in sql?

1007

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

986

What is normalization of database?

1019

Explain different backup plans?

881

What is the purpose of floor function?

975