Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

Which table keeps information about stored procedures?

0 Answers  

---

Can we use having clause without group by?

0 Answers  

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

Explain what is public role in sql server?

0 Answers  

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

What is the difference between update lock and exclusive lock?

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  

---