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's the maximum size of a row? : Sql server database administration

1154

What is a data source file?

1020

What are the two authentication modes in sql server?

1167

What is a transact-sql statement batch in ms sql server?

1063

What is RMS migrations?

2188

What is the command dbcc checkdb used for?

1067

How do I perform an unattended install of sql server 2000?

1134

Explain identity in sql server?

1049

What is dbcc?

1177

What are scalar functions?

1046

What is the parse query button used for?

1079

what are the core components of SSRS?

135

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1038

What are logical/boolean operations in ms sql server?

1100

Tell me what do you understand by a view? What does the with check option clause for a view do?

1059