How can we check the sql server version?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

What is bcp? When does it used?

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

---

Explain how does the report manager work in ssrs?

0 Answers  

---

Why union all is faster than union?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---