Answer / Pankaj Kumar Chauhan

The SIGN() function in SQL Server returns -1, 0, or 1 based on whether the argument is less than 0, equal to 0, or greater than 0 respectively. It can be used for determining the sign (positive, negative, or zero) of a numeric value.

How to convert character strings into numeric values?

0 Answers  

---

Disadvantages of the indexes?

0 Answers  

---

what is web server?

3 Answers   Satyam,

---

What is change tracking in sql server?

1 Answers  

---

Explain what is cte (common table expression)?

1 Answers  

---

How does stuff differ from the replace function?

1 Answers  

---

How to drop an existing stored procedure in ms sql server?

1 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

Find first and last day of current month in sql server

1 Answers  

---

Do you know what are various aggregate functions that are available?

1 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1 Answers  

---