A function can return a value whereas a procedure cannot return a value.

What is the difference between Procedure and Function

Question Posted / paporirokz

Answer Posted / paporirokz

A function can return a value whereas a procedure cannot
return a value.

Is This Answer Correct ?

17 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Do you know what are the steps to process a single select statement?

960

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1039

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1022

What is partition in sql server?

1028

Different types of keys in SQL?

1088

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

955

What is merge replication?

1097

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

989

Can a cursor be updated? If yes, how you can protect which columns are updated?

1098

What is row-level compre?

990

Does a full backup include transaction log?

959

How to Insert multiple rows with a single insert statement?

1045

What is postgresql server?

990

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

933

What is the purpose of floor function?

1027