What are the different types of replication you can set up in sql server?

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,

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

Define compound operators?

0 Answers  

---

how to know description of a table in sqlserver 2000

8 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Explain error and transaction handling in sql server?

0 Answers  

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

Why functions are used in sql server?

0 Answers  

---

What does top operator do?

0 Answers  

---