Answer / Shivam Shukla

When null values are involved in arithmetic operations, the result will be NULL unless you use ISNULL(), COALESCE(), or another method to handle null values.

Where in ms sql server is ’100’ equal to ‘0’?

1 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

1 Answers  

---

How to convert numeric values to integers in ms sql server?

1 Answers  

---

Tell me about joins in database system and explain each in detail.

1 Answers   Axtria, ITC Indian Tobacco Company,

---

Explain what is row_number function?

1 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Difference between drill down and drill through report.

1 Answers  

---

What are the new scripting capabilities of ssms? : sql server management studio

1 Answers  

---

How to enter binary string literals in ms sql server?

0 Answers  

---

How to update multiple rows with one update statement in ms sql server?

1 Answers  

---