How to list all tables in the database using odbc_tables()?
No Answer is Posted For this Question
Be the First to Post Answer
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
Explain user defined views?
What is log ldf?
How the data stores in a page?
What happens if ntwdblib.dll is missing on your machine?
Is candidate a key?
Can binary strings be used in arithmetical operations?
How to start and end transact-sql statements?
How we Resize table,temp table, database and log file size in SQL Server 2005
application server is slow what may be the problem
How many joins in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?