Data Engineering

Null values and their pitfalls

Null values and their pitfalls

Hung Manh Aug 6, 2020 4 min read

Learning: Best to not permit NULL values in columns which are used for comparisons

Passing comma separated String to function / stored procedure to use with IN condition

Passing comma separated String to function / stored procedure to use with IN condition

Hung Manh Apr 28, 2020 1 min read

[..] passing comma separated variables into a function does not seem to allow the use of the variable directly in the IN condition.

Add leading zeroes to time

Add leading zeroes to time

Hung Manh Apr 24, 2020 1 min read

When a time is saved as integer the leading zeroes will not be saved.

hungsblog | Nguyen Hung Manh | Dresden
Scroll to Top