What is view in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the ‘fillfactor’?
Define the term DML, DDL and DTL?
Tell me what is normalization? Explain different forms of normalization?
How do I debug a stored procedure in sql server?
How to create Clustered Primary Key to table?
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
How to disable stored procedure sql server?
What is merge replication?
Tell me what is sql profiler?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
how to retrive only second row from table in sql server 2000?
How to access the deleted record of an event?