How does recursive cte works in sql server?

0 Answers  

---

What is Index Segmentation ?

1 Answers   TCS,

---

What is the downside of using udf?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

Explain filtered indexes?

0 Answers  

---

syntax for deleting the database in T SQL

5 Answers  

---

What are the difference between “where” and “having” clause in sql server?

0 Answers  

---

In which files does sql server actually store data?

0 Answers  

---

What are the restraints imposed on the table design by a merge replication?

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 attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---