What is the process of normalization?

0 Answers  

---

find the 3rd max salary

10 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,

---

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 are the properties of primary key?

0 Answers  

---

What is log ldf?

0 Answers  

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

What is the parse query button used for?

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---