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

Where is localdb stored?

756


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

710


Why olap is used?

747


tell me the disaster recovery plan

2222


Explain the different index configurations a table can have?

710


Difference between primary key and clustered index?

712


How to get a list of columns in a view using the "sp_columns" stored procedure?

823


List the different normalization forms?

738


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

714


What is built-in/administrator?

764


What is similarity and difference between truncate and delete in sql?

825


What is partition in sql server?

745


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

734


What is row_number function?

766


What are the advantages of having an index on the sql server?

713