Answer Posted / uday

Sp is nothing but Group of T-Sql Statments compiled into a
single execution plan.

Sy: create procedure Pname

{@parameter1 datatype,@parameter2.........)
as

SQL Statments

end

Plz let me know if i am wrong
uday_testing@yahoo.co.in

what are date and time data types? : Sql dba

1028

---

Is oracle sql free?

1039

---

What is the current version of postgresql?

1128

---

What are the types of triggers in sql?

1143

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1117

---

Do we need to rebuild index after truncate?

1098

---

Can we create clustered index without primary key?

1002

---

what is unique key constraint? : Sql dba

1099

---

What is sql injection vulnerability?

1005

---

What is a sql schema used for?

1156

---

What is mutating sql table?

1160

---

Explain unique key in sql.

1063

---

Is postgresql a nosql database?

1228

---

what is difference between delete and truncate commands? : Sql dba

1173

---

What are the disadvantages of not performing database normalization?

1216

---