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

What is change data capture (cdc) in sql server 2008?

566

Explain about the command-line tool SQLCMD?

557

What is linked report?

what is a transaction? : Sql server database administration

473

Explain how many types of relationship?

575

How to write a query with a full outer join in ms sql server?

560

What stored procedure would you use to view lock information?

530

What is the contrast amongst drop and truncate?

562

What happens when transaction log is full?

515

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

654

What is dknf in normalization form?

557

What is data compression?

548

What happens if strings are casted into wrong code pages in ms sql server?

569

Does a full backup include transaction log?

485

What is the syntax to execute the sys.dm_db_missing_index_details?

588