How you can move data or databases between servers and databases in sql server?

0 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---

What is standby servers? Explain types of standby servers.

0 Answers  

---

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

Explain where clause?

0 Answers  

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

What is a transaction and what are ACID properties?

3 Answers  

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---