1) how to delete duplicate records from table in sql server
2005
2) what is run time polymorphism
Answers were Sorted based on User's Feedback
Answer / kishore
select distinct * from Mytable
select distinct * into Newtable from Mytable
drop table Mytable
select * into Mytable from Newtable
Is This Answer Correct ? | 12 Yes | 7 No |
Answer / shailesh
2>Polymorphism is done by two way Overloading and
overriding.Overriding is called the runtime Polymorphism.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / reva
DELETE FROM tableName WHERE id NOT IN
(SELECT MIN(id) FROM tableName GROUP BY name)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / nkm
SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1
Is This Answer Correct ? | 4 Yes | 14 No |
can any one send the project manager questions in .net
What is difference between int and int32 in c#?
What happens if the inherited interfaces have conflicting method names?
List the two important objects of ado.net and also list the namespaces that are commonly used in ado.net to aid in connection to a database.
What is literal control
Explain the types of Polymorphism.
In a C# class we have a SortedList member m_addinProjects we want to provide an iterator to allow the consumer of this class access to the items in the collection. Please provide an iterator method for the AnalyzeAddinsDLL class below and an example of how it would be used. namespace AnalyzeAddinsDLL { public class AllAddInProjects { private SortedList<string, AddInProject> m_addinProjects; public AllAddInProjects() { m_addinProjects = new SortedList<string, AddInProject>(); } } }
What are object pooling and connection pooling and difference between them?
Define clr in .net?
What is the ouput of the following program?
Any .net training centers available near hitech city , hyderabad?
what are some characteristics of an array?