What is the difference between set and select?
No Answer is Posted For this Question
Be the First to Post Answer
What are the recovery models in sql server 2000?
What is RAID and what are different types of RAID configurations?
What are the two types of concurrency?
Explain the dirty pages?
What is the difference between DTS and SSIS?
what is the different types of backups available in sql server? : Sql server database administration
What are the difference between data length and length in SQL Server-2008?
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM
In which format does an image save in SQL Server database ?
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 is a cube? : sql server analysis services, ssas
How to delete existing triggers using "drop trigger"?