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

How are the unique and primary key constraints different?

571

What are the different sql server versions?

523

What are the types of subscriptions in SQL Server replication?

554

What is the recursive stored procedure in sql server?

530

List the different types of collation sensitivities in sql server?

537

What is a periodical index?

510

How to create hyperlink from returned sql query ?

629

Explain what is use of dbcc commands?

517

What are distinctive joins find as a part of sql?

560

Are connections to sql server encrypted?

580

Explain system rowset functions?

564

Explain the working of sql privileges?

611

How to execute stored procedure and set temp table in sql server?

560

Explain external key management in sql server 2008

508

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

585