What is difference between stored procedure & function?

Answer Posted / shreenath27@yahoo.co.in

function will return value but procedure will not return any
value

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by acid?

580


What are the new features in sql server 2016?

550


What are transactions in sql?

556


What is the use of builtinadministrators group in sql server? : sql server security

537


Why do we use sql limitations? Which constraints can we use while making a database in sql?

565






Define inner join in sql server joins?

535


What is the standby server?

523


What is meant by Active-Passive and Active-Active clustering setup?

568


How to integrate the ssrs reports in application?

544


Explain the functionalities that views support?

697


define and explain the differences between clustered and non-clustered indexes.

601


Explain few examples of stored procedure over triggers?

525


After removing a table from database, what other related objects have to be dropped explicitly?

560


Other than truncate statement, which other command can by-pass the trigger on the tables?

624


what is a deadlock? : Sql server database administration

503