Finding Duplicate Records In a Database Table

Ideally business rules, that can be re-enforced at the database layer, should be implemented at the database layer to ensure that the integrity of the data can be relied on and does not lead to an unexpected behaviour from the application. Rules such as validation rules, e.g., which fields/columns cannot be null, etc. common sense … Continue reading Finding Duplicate Records In a Database Table

Advertisements

A Regular Expression (RegEx) To Match Integers and Doubles

These regular expressions matches both the positive and negative variations of the data types specified below integers - e.g., 1, 89, 81223, -7, etc. floating point numbers (doubles or floats) - e.g., .0, 59.3, 300.12, -.87   The adopted approach was to avoid nested expressions which is not needed if it is only the number … Continue reading A Regular Expression (RegEx) To Match Integers and Doubles