Answer / Priyanka Kumari

There are three main types of collation sensitivity in SQL Server: case sensitive, accent sensitive, and binary. Case sensitivity compares uppercase and lowercase letters as different characters, while accent sensitivity compares accented characters as different characters, and binary comparison is a binary comparison with no regard for accents or case.

What are the source of constraints?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1 Answers  

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1 Answers  

---

Can a unique index be created on a column, which contains null?

1 Answers  

---

Explain the working of sql privileges?

1 Answers  

---

Define left outer join in sql server joins?

1 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers   BirlaSoft,

---

What is the significance of master, tempdb and model databases?

1 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

What is system stored procedures?

1 Answers  

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1 Answers  

---

Define left outer join?

1 Answers  

---