Explain what is cte (common table expression)?

0 Answers  

---

How many joins in sql server?

0 Answers  

---

Why normalization is used?

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

What is sql injection? How to protect against sql injection attack?

0 Answers  

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

what are the Prerequisites for Replication?

1 Answers   IBM,

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Define primary key?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---

What is normalization?

9 Answers  

---