Is truncate autocommit?

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,

---

What according to you is the difference between mysql and sql server performance?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

How to maintain a fill factor in existing indexes?

0 Answers  

---

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

Tell me what is fill factor?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---