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,

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

Why would you use sql agent?

0 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---

Explain relational data?

0 Answers  

---

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What are the properties of primary key?

0 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---