Can we take the full database backup in log shipping?

0 Answers  

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 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 work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

What is full form of XP ?

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

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

How to set a database state to offline in ms sql server?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

Can select statements be used on views in ms sql server?

0 Answers  

---

How to access the inserted record of an event?

0 Answers  

---

Which autogrowth database setting is good?

0 Answers  

---

What is the contrast between sql and pl/sql?

0 Answers  

---