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 |
Explain how to parse a datetime string?
Suppose you have already existing application with Visual Studio 6 (VB 6, InterDev 6) and this application utilizes Windows 2000 COM+ transaction services. With this example how can you approach migrating this application to .NET?
What is the difference between interface and abstract class in c#?
How do you generate documentation from the C# file commented properly with a command-line compiler?
What are native methods?
What is oledb in c#?
what is bubbled event ? give suitable example in code vice with demo
What is xml serialization and deserialization in c#?
What the different phase/steps of acquiring a proxy object in webservice?
What is platform independence"?
What is fcl in c#?
In .NET how can you solve the DLL Hell problem?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)