What is an expensive query?

0 Answers  

---

What is the use of CASCADE CONSTRAINTS?

3 Answers  

---

What is reference section?

0 Answers  

---

What are the results of running this script?

0 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What is dbcc command in sql server?

0 Answers  

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---

What are the differences between left join and inner join in 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 lookup override?

0 Answers   Informatica,

---

Why use update_statistics command in sql server?

0 Answers  

---