What is the difference between Procedure and Function

Answer Posted / khaleek.ahmad

9.There is possible of recursive function like
max(min(something)),but there is nothing like in procedure.

10.We can call a function from a procedure, but it is not
possible to call a procedure from a function

For more detail , please see at.
http://interview-preparation-for-you.blogspot.com/2010/05/difference-between-function-and.html

Is This Answer Correct ?    3 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to disconnect from a sql server using mssql_close()?

597


What is Federation and Federation Member?

80


How to perform backup for certificates in sql server? : sql server security

604


What are views used for?

626


Do you know what is lock escalation?

594






What are commonly used odbc functions in php?

548


What is a natural primary key?

531


Tell me what is the order in which the sql query is executed?

538


What is BCNF? How is it better than 2NF & 3NF?

604


How sql server executes a statement with nested subqueries?

515


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

646


Explain what is “asynchronous” communication in sql server service broker?

507


What are the different types of locks in the database?

493


What is an sql server agent?

555


What are the functions in sql server?

551