What is Self Join?

4 Answers  

---

Tell me what do we need queues in sql service broker?

0 Answers  

---

What is the server name in sql server?

0 Answers  

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

How do you create an execution plan?

0 Answers  

---

Explain view in sql server?

0 Answers  

---

How to select true false based on column value in sql server?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

How do I open port 1433?

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,

---