What is the use of nvl work?

0 Answers  

---

What are the types of constraints?

1 Answers  

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Can we write ddl in trigger?

0 Answers  

---

---

What is the difference between locking and multi-versioning?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What is inner join? Explain with an example?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

What does the automatic recovery do?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---