What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

What is xdr?

0 Answers  

---

Explain collation?

0 Answers  

---

what is node in sql server?

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

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

We need to perform what steps in the following order to work with a cursor?

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 is Equity join?

2 Answers   ADP,

---

Explain the difference between cross join and full outer join?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

What are commonly used mssql functions in php?

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---