Interested to Buy Any Domain ? << Click Here >> for more details...
Can select statements be used on views in ms sql server?
- 0 Answers
- 1065 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to generate create table script on an existing table in ms sql server?
What is normalization 1nf 2nf 3nf?
What is the use of partition by in sql server?
Is truncate a dml command?
What are a scheduled jobs or what is a scheduled tasks?
What are the advantages dts has over bcp?
when we use function instead of procedure? plz tell me the situation with ex?
What is the recovery model? List the types of recovery model available in sql server?
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
What are date and time data types in ms sql server?
What happens if we shrink log file in sql server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
