Removing Duplicate Records from SQL Server Table

In recent few interviews there was a scenario that interviewer asked me to remove duplicate records from SQL Server table. For example: There is a table with 3 columns (COL1, COL2, COL3), having duplicate data stored like below screen shot of the table. If you can carefully look at the records you can find that […]

Read more โ†’

Static Constructors, Life time and Use

It’s a quick article. In a technial interview, panel has asked me about the static constructors and how and when static constructors will be called etc. He wrote a program to extract more idea from me through.  I recreated the program to explain about it. Before going further I will fill in details about STATIC constructors. A static […]

Read more โ†’

SOAP – Protocol or Message Exchange Pattern

In a recent interview I have been asked What is SOAP? Is it a Protocol or Message Pattern. It’s stupid that i was confused by the question and simply said “Message Exchange Pattern”, to my knowledge As the name states it’s a Protocol. Message Exchange Pattern(MEP) is part of a SOAP, where the description of […]

Read more โ†’