What is the difference between constraints and triggers?

9 Answers   Wipro,

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

How to get number of days in a given year?

4 Answers   ADP,

---

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 you leave a union at any time?

0 Answers  

---

---

What are the filtered indexes?

0 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

How to view existing indexes on an given table using sp_help?

0 Answers  

---

How to set a database state to offline in ms sql server?

0 Answers  

---