Difference between Function and Stored Procedure?

Answer Posted / yatendra

fuction used by mad people

while sp used by clever people

Is This Answer Correct ?    5 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between lock, block and deadlock? : sql server database administration

562


How to download and install microsoft sql server management studio express?

561


What are the steps to insert a table?

539


How do we synchronize On-Premise SQL server with SQL Azure?

96


Why should one not prefix user stored procedures with ‘sp_’?

590






You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

581


What do you understand by user-defined function in the sql server?

486


What is the order in which the sql query is executed?

521


What is ms sql server index?

560


What are the types of table?

545


Differentiate between SQL and ORACLE joins and write their syntax.

587


Can you explain different types of locks in sql server?

523


If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

552


Which are the olap features?

546


What does ss stand for sexually?

579