1) how to delete duplicate records from table in sql server
2005

2) what is run time polymorphism

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is definition in c#?

480


Is null in c#?

489


What is data binding with example?

499


What is the difference between Java and .NET garbage collectors?

513


Why can’t struct be used instead of class for storing entity?

486






What is the implicit name of the parameter that gets passed into the class set method?

494


What does clr stand for?

478


Why extension method is static?

472


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 m_addinProjects; public AllAddInProjects() { m_addinProjects = new SortedList(); } } }

1816


How more than one version of an assembly can keep in same place?

516


Enlist some of the properties of a thread class?

513


What are the Types of caching

543


What is string in c# net?

498


What is arraylist?

542


Why do we use overloading in c#?

481