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

Can we use update in sql function?

1069

---

How many sql core licenses do I need?

953

---

What is t-sql? : Transact sql

994

---

What is a trigger word?

1031

---

What is use of trigger?

937

---

What is plpgsql language?

1070

---

How to add a column ‘salary’ to a table employee_details?

1016

---

Why do we use procedures in pl sql?

1047

---

Can a foreign key be a duplicate?

915

---

Is big data nosql?

957

---

How many aggregate functions are available there in sql?

988

---

What is number function in sql?

980

---

What is foreign key sql?

994

---

Why coalesce is used in sql?

1016

---

What is a sql*loader control file?

1274

---