How many types of local tables are there in sql server?

0 Answers  

---

What is a mixed extent?

0 Answers  

---

What is bcnf normalization form?

0 Answers  

---

What is a SQL Server Temporary Table?

1 Answers   Wipro,

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

How do you know which index a table is using?

4 Answers  

---

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

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,

---

Do you know what is normalization of database? What are its benefits?

0 Answers  

---