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

how are mysql timestamps seen to a user? : Sql dba

1048

---

What are the types pl/sql code blocks?

1067

---

What is the maximum rows in csv?

857

---

Explain 3 basic parts of a trigger.

1255

---

Can we create foreign key without primary key?

931

---

How to select 10 records from a table?

1097

---

Mention what pl/sql package consists of?

938

---

What is a unique constraint?

1011

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1064

---

How do you write an inner join query?

890

---

Is it possible to create startup or shutdown trigger for on-schema?

979

---

What does an inner join do?

1090

---

What is the trigger in sql?

903

---

Difference between global and parameter variables?

1906

---

What are the subsets of sql?

1037

---