Explain what is row_number function?

0 Answers  

---

How to create indexed view?

0 Answers  

---

How to access the inserted record of an event?

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 are the kinds of subquery?

0 Answers  

---

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

What is sqlcmd?

0 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

What is log ldf?

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---