Answer / Saurabh Singh Chauhan

SQL Collation is a set of rules that determines how SQL Server compares and sorts data. It includes the sorting order for characters, as well as the rules for case sensitivity, accent sensitivity, and other factors. Collations are used to ensure compatibility between different databases or even different languages.

List all types of constraints in sql server?

1 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

what are constraints? Explain different types of constraints? : Sql server database administration

1 Answers  

---

Explain features of analysis services?

1 Answers  

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1 Answers  

---

How to make remote connection in database?

1 Answers  

---

How can I change procedure name in sql server?

1 Answers  

---

Explain different types of Normalization.

2 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

what is isolation level at dead lock?

1 Answers   Verizon,

---

What is filestream?

1 Answers  

---