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

What area unit the various kinds of info compression introduced in sql server 2008?

573


How many ways to create table-valued functions?

586


Difference between Logical Page and Physical Page in SSRS.

340


What is self contained scalar sub query?

541


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2211






Do you know the policy based administration feature of sql server 2008?

580


What is the difference between for xml raw and for xml auto?

569


What is dbcc? Give few examples.

582


What is the New in SQL server 2008?

583


What is a constant or literal in ms sql server?

599


You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

541


Explain a checkpoint?

538


What is a performance monitor?

558


How do I create a partition table in sql server?

499


what are the critical issues you have resloved in your company

1553