What is the difference between row_number and dense_rank?

0 Answers  

---

What happens if null values are involved in arithmetic operations?

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

What is inner join? Explain with an example?

0 Answers  

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---