Friday, June 26, 2009

How to get Duplicate records in a Table

Last day, I seamlessly entered into a situation where I want to list out all the repeating/duplicate records from a table. Though it sounds simple, its bit a tricky approach.

As a small example: consider a table say RepeatTest having 2 fields: Id and Url. To figure out the repeating Url records, you can write the query as:

   1:  
   2: SELECT Url, count(Url) FROM RepeatTest
   3:     GROUP BY Url
   4:         HAVING (COUNT(Url)>1)
   5:  

Sometimes you may also jump into sudden simple queries, as what I’d jumped into.

Update: This simple question was asked for the Huwaei International's written exam, held at Bangalore on July 2009.

Thursday, June 25, 2009

Automatic Implemented Properties in .NET 3.5

One of the cool feature that I like in .NET 3.5 is the automatic implementation of Properties in .NET 3.5. Here is a sample:

   1:  
   2: private string _name
   3:  
   4: public string Name
   5: {
   6:     get
   7:     {
   8:         return _name;
   9:     }
  10:     set
  11:     {
  12:         _name = value;
  13:     }
  14: }

Can be re-written as:

   1:  
   2: public string Name {get; set;}
   3:  

Saturday, June 20, 2009

Operation aborted in IE8

Dear Readers/Visitors, as you might know you may receive an “Operation Aborted” error message, when visiting my blog using Internet Explorer. Honestly, I don't know what had happened. How sad. (I’m an IE Lover…!!!).

I’ve posted the issue in IE MSDN Forum. Though they helped, but was not solved completely. Also, they have provided some troubleshooting methods to solve the issue. If you are experiencing the same problem of “Operation Aborted” exception, then have a look at the discussion here.

Thanks.

Update: I think the problem is solved now. I'm not getting the error message. What about you guys?

 
Best viewed in Internet Explorer 8.