Answer / Sinkesh Kumar

To rename an existing column using SQL Server Management Studio, follow these steps:
1. Open the table designer and select the table.
2. Right-click on the column you want to rename and choose 'Rename' from the context menu.
3. Type the new column name and press Enter.

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 changed between the previous version of sql server and the current version? : Sql server database administration

1 Answers  

---

Distinguish between commit and rollback?

1 Answers  

---

Which Model uses the SET concept

1 Answers   Infosys,

---

how you can list all the tables in a database?

1 Answers  

---

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

1 Answers  

---

What are synonyms?

1 Answers  

---

what is a correlated sub-query? : Sql server database administration

1 Answers  

---

How to filter records of table in SQL SERVER?

1 Answers   Petranics Solutions,

---

Differentiate between delete and truncate.

1 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

---