What is an index in sql?

0 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

How to create new tables with "create table" statements in ms sql server?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

---

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

0 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

What is the difference between rank and dense_rank?

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring?

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,

---

When would you use sql joins?

0 Answers  

---