Is the log file is a part of file group?

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---

What is a document index?

0 Answers  

---

How to enter binary string literals in ms sql server?

0 Answers  

---

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

Explain the third normal form(3nf)?

0 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

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,

---