1) how to delete duplicate records from table in sql server
2005
2) what is run time polymorphism
Answer Posted / nkm
SELECT col1,col2 FROM tDupData
GROUP BY col1,col2
HAVING COUNT(*) > 1
Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
In which format you can pass the value in the sleep function?
What are reflections in c#?
What is a byte in c#?
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.
Between windows authentication and sql server authentication, which one is trusted and which one is untrusted?
How do you specify a custom attribute for the entire assembly (rather than for a class)?
Give examples for value types?
Explain about CTS?
What is difference between asp net and c# net?
Can properties be private in c#?
what will be the output of the given below coding. using System; public class Exercise { static void OddNumbers(int a) { if (a >= 1) { Console.Write("{0}, ", a); a -= 2; OddNumbers(a); } } public static int Main() { const int Number = 9; Console.WriteLine("Odd Numbers"); OddNumbers(Number); Console.WriteLine(); return 0; } }
How can I access the registry from c# code?
What is the difference between field and property in c#?
How to sign an assembly with strong name?
Can you explicitly call a destructor?