What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

How to use user defined functions in expressions?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

A trigger can reference objects outside the current database? State true or false.

0 Answers  

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

Explain features and concepts of analysis services?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

Explain Different types of Projects?

1 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

What is Right Outer Join?

2 Answers  

---