What is order of B+tree?

0 Answers   HCL,

---

How can you insert null values in a column while inserting the data?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

How do you manipulate data?

0 Answers  

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

What do you know about system database? : SQL Server Architecture

0 Answers  

---

What is recompile sql server?

0 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

What are orphan records?

0 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

What is outer join in sql server joins?

0 Answers  

---