what is procedure in sql?

Answer Posted / sudarshan

Procedure is a collection of simple DML statements used to
perform certain meaningful operation stored in the database
and used whenever and wherever required.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger and different types of Triggers?

578


How do I make a resultset scrollable?

515


What is database mirroring?

567


What is difference between index and primary key?

590


What program is used to store the data source file?

505






Where do we use trace frag?

574


Difference between Inner vs outer joins?

535


How to query multiple tables jointly?

560


What are dml (data manipulation language) statements in ms sql server?

556


What number aggregate functions are accessible there in sql?

593


Explain the steps needed to create a scheduled job?

525


What is a field name?

515


Do you know sql server 2008 backup compression?

568


Tell me what is use of except clause? How it differs from not in clause?

518


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1429