Where views are stored in sql server?

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

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 the use of toad or sqldbx.?

0 Answers   MCN Solutions,

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

Explain what is row_number function?

0 Answers  

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

Explain stored procedure?

0 Answers  

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---

What are commonly used odbc functions in php?

0 Answers  

---