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 is a data definition language?

1126

---

Cite the differences between execution of triggers and stored procedures?

1077

---

What is normalisation and its types?

1004

---

what is the difference between char and varchar data types? : Sql dba

1112

---

Which join is default?

952

---

what are the advantages of using stored procedures? : Sql dba

1105

---

How do you optimize a stored procedure in sql?

957

---

Differentiate between sga and pga.

1163

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

---

What is acid property in a database?

1034

---

What is union and union all keyword in sql and what are their differences?

1106

---

what are tables and fields? : Sql dba

1055

---

How do I count rows in sql query?

988

---

Explain the difference between rename and alias?

1010

---

what is the difference between a web-garden and a web-farm? : Sql dba

1081

---