Does sql server use t sql?

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  

---

What is de-normalization and when do you do it?

3 Answers  

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

Explain following error properties?

0 Answers  

---

Explain the different types of joins?

0 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

What is an index in sql?

0 Answers  

---

How to convert numeric expression data types by assignment operations?

0 Answers  

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

Does index speed up select statements?

0 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---