Difference between Function and Procedure-in general?

Answer Posted / rohan

function can be written in select statement but stored
procedure cannot be written in a select statement

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we write ddl in trigger?

691


Explain what are various ways to enhance the ssrs report?

844


Can you use order by when defining a view?

794


How to apply cascading referential integrity in place of triggers?

795


Explain the microsoft sql server delete command?

744


Do you know what are different types of replication in sql server?

790


What is report subscription?

111


What is normalization of database? What are its benefits?

743


What is a cursor, index in sql?

829


What are the main sources of data?

866


What happens to a trigger with multiple affected rows?

732


Can we hide the definition of a stored procedure from a use?

924


What is provisioning, billing and metering, and connection routing concepts in the service layer?

109


Differentiate between ms sql server reporting services vs crystal reports?

709


What is the cartesian product of the table?

761