What's the purpose of Stored Procedure?

Answer Posted / suresh

Stored Procedure Accept input Parameter,So a single stored
procedure can use Over the Network by several Clients by
Passing several Input values

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me when is the update_statistics command used?

515


How will you decide the active and passive nodes?

642


Can group functions be mixed with non-group selection fields in ms sql server?

545


How to recompile stored procedure at run time?

571


Explain the dirty pages?

580






last function used in MS Access to convert sql what function will use in sql

1612


How to create a Master database in SQL server ?

551


What encryption security is available in sql azure?

81


What is sql stored procedure?

601


Mention a few common trace flags used with sql server?

544


What are the different types of replication you can set up in sql server?

531


What is difference between view and materialized view?

540


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

584


What are acid properties of transaction?

555


What is it’s similarity with sql server?

143