What is raiseerror? What is raiseerror?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

Explain what is cte (common table expression)?

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

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,

---

What is the difference between varchar and varchar types?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

How to use clusters?

0 Answers   Amdocs,

---

What the different components in replication and what is their use?

0 Answers  

---