Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

What is the partitioning method?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is the maximum row of a size?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

---

Explain nested join?

0 Answers  

---

What is a sql join?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

Define msdb database?

0 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---