Can you explain important index characteristics?

0 Answers  

---

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

0 Answers  

---

Explain system rowset functions?

0 Answers  

---

What is the use of partition by in sql server?

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---

Explain the different types of joins?

0 Answers  

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What is inline table-value user-defined function?

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,

---

Where is my database stored on the hard disk in ms sql server?

0 Answers  

---