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

Explain table valued parameters in sql server? Why tvp used?

1065

What is replication with database mirroring? : sql server database administration

1144

How would you choose between a clustered and a non-clustered index?

1018

How to find tables without indexes?

1145

How to get nth highest salary from employee table.

1206

What is the significance of null value and why should we avoid permitting null values?

1029

Tell me about pre-defined functions of sql?

1155

What is a ddl statement?

958

What is the command dbcc checkdb used for?

1067

Does a sql server 2005 select statement require a from?

1068

How to fine-tune reports?

279

How to count rows with the count(*) function in ms sql server?

1055

How do you delete duplicate records in sql server?

1121

What is dbcc updateusage?

1251

How to replace null values in expressions using isnull()?

1149