Answer / Uma Kaushik

Collation sensitivity refers to how a database management system treats different characters, such as case (upper and lower) or diacritics. SQL Server has several collations that can be set at different levels, including server-wide, database-level, and table-level collations.

How can you save or place your msg in a table?

1 Answers  

---

Explain the components of sql?

1 Answers  

---

What are reports usually used for?

1 Answers  

---

Explain the advantages and disadvantages of stored procedure?

1 Answers  

---

How to disable a trigger name update_salary?

1 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is the difference between an inner join and an outer join?

1 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1 Answers  

---

Can we call procedure in select statement?

1 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

1 Answers  

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---