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 are the parts of a function?

517

What is set nocount on and what is set nocount off?

508

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

582

Can we do dml on views?

544

what is the maximum size of a row? : Sql server database administration

526

What is the difference between for xml raw and for xml auto?

557

What is database black box testing?

601

What will be query used to get the list of triggers in a database?

538

What is filtered index?

646

What is nonclustered index on computed columns?

566

What is transaction server isolation?

570

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

What is temporary table in sql server? Why we use temp table?

509

How do I run a trace in sql server?

494

What are the restrictions applicable while creating views? : SQL Server Architecture

579