What is rank function?

0 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

Explain indexing and what are the advantages of it?

0 Answers  

---

How to link tables in sql server?

0 Answers  

---

Does a server store data?

0 Answers  

---

What is the purpose of indexing?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

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

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

How can you control the amount of free space in your index pages?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---