How to get the query of a table in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are xml indexes?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
What are examples of triggers?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
what are the different types of replication you can set up in sql server? : Sql server database administration
What is temporary table in sql server? Why we use temp table?
How to use user defined functions in expressions?
What is sub-query in sql server? Explain its properties.
What is the difference between a view and a stored procedure?
Creating Tables Using SELECT
What are the commands used in DCL?
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