Why use identity in sql server?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

How would you add a section to a table?

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,

---

How can a database be repaired?

0 Answers  

---

What is a Linked Server?

1 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

What is an indexing strategy?

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---