Differentiate between a local and a global temporary table?

0 Answers  

---

Which are the olap features?

0 Answers  

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 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,

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

What is a mixed extent?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

What do you mean by authentication modes in sql server?

0 Answers  

---

What happens when transaction log is full?

0 Answers  

---