What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

How many instances per computer are there in sql server 2000?

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

---

What are the different index configurations a table can have?

0 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

Explain cursor as data base object?

0 Answers  

---

How to encrypt data between dialogs?

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,

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

how you can list all the tables in a database?

0 Answers  

---