Answer Posted / roshan kumar

Procedure-

A procedure is a specified series of actions,acts or operations which have to be executed in the same mannner in order to always obtain the same result under the same circumstances.

Stored Procedure-

A stored procedure is a subroutine available to applicATIONS accessing a Relational database system.stored procedures(sometimes called as proc,sproc or sp) are actually stored in database dictionary.

How do I remove duplicates in two columns?

974

---

What is the use of stored procedures?

972

---

What is rename command in sql?

950

---

can sql servers linked to other servers like oracle? : Sql dba

952

---

What is sql query optimization?

1018

---

What is trigger and stored procedure in sql?

975

---

What are sql triggers used for?

953

---

What is %type in pl sql?

922

---

How can I change database name in sql?

1000

---

Which function is used to return remainder in a division operator in sql?

1073

---

What are the subsets of sql?

1032

---

how would concatenate strings in mysql? : Sql dba

1010

---

What is package in pl sql?

961

---

Is vs as in pl sql?

932

---

how to dump a table to a file with 'mysqldump'? : Sql dba

981

---