What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

How many commands are there in sql?

0 Answers  

---

What is sql catalog?

0 Answers  

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

Is left join faster than join?

0 Answers  

---

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---