What is global temp table?

0 Answers  

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

What is transact-sql language?

0 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

What does COMMIT command do?

0 Answers   Amdocs,

---

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

How to delete an attribute from the emp table

4 Answers  

---

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

---

What is a trigger?

7 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,

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---