How to create a view with data from multiple tables?

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,

---

Explain the difference between function and stored procedure?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What do you mean by tablesample?

0 Answers  

---

What are information schema views?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

What is full form of XP ?

42 Answers   Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

---

How to download and install the scaled-down database adventureworkslt?

0 Answers  

---

What is tcl in sql server?

0 Answers  

---

What is the difference between left and right outer join?

0 Answers  

---

What command do we use to rename a db?

5 Answers   IBM,

---