What are date and time data types in ms 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,

---

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

Define outer join?

0 Answers  

---

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---

How do I view a stored procedure in sql server query?

0 Answers  

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---