Answer Posted / kishore

select distinct * from Mytable
select distinct * into Newtable from Mytable
drop table Mytable
select * into Mytable from Newtable

What is difference between function and method in c#?

907

---

Can var be null c#?

878

---

What is the .net datatype that allows the retrieval of data by a unique key?

906

---

There were a lot of questions asked, so I will list the topic (and add a what is "topic" and know pros/cons). Extreme programming, what is a transaction, various SDLC design approaches, what is a namespace, define a good test case, what is a stored proc, webservice? design patterns? linker? compiler? access modifiers? stack vs. queue? arrays vs. linked lists? sorting algorithms? recursion? OOP principles?

2025

---

Can we create instance of private class in c#?

908

---

What is .cs file in c#?

931

---

What is lazy keyword in c#?

911

---

What is the advantage of extension method in c#?

887

---

What is virtual in c#?

888

---

What is a Jagged Array in C#?

1009

---

Can mvc be used for desktop applications?

967

---

Which of the following API is used to hide a window?

1033

---

Why do we need oops in c#?

945

---

What is ado c#?

954

---

Are arrays value types or reference types?

940

---