What is ms sql server index?

0 Answers  

---

Do you know what is a linked server in sql server?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

---

What is trigger in salesforce?

0 Answers  

---

What is the difference between a clustered index and a non-clustered index?

0 Answers  

---

What's the maximum size of a row?

4 Answers   IBM,

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

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,

---

How to restore performance issues and how to check?

0 Answers  

---

How to remove duplicate rows from table except one?

0 Answers  

---