What is the usage of the sign function?

1 Answers  

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

what authentication modes does sql server support? : Sql server database administration

1 Answers  

---

How to view existing indexes on an given table using sys.indexes?

1 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

1 Answers   Wipro,

---

What does the not null constraint do?

1 Answers  

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1 Answers  

---

What do you understand by coalesce in sql server?

1 Answers  

---

Do you know what are the properties of the relational tables?

1 Answers  

---

Mention the differences between substr and charindex in sql server.

1 Answers  

---

Explain the collation?

1 Answers  

---