Hi everybody,
I added an extra table called Membership to my database. I found that I'm unable to use NULLs for the fields, so I have to convert data to not NULLs. I'm doing this in my SP to retreive data.
But now I'm facing a problem of updating the info. I only want to insert/update record if I put some information. However, how now I can detect if I did make changes or not?
I'm converting bit fields to 0, date to GetDate() and varchar field to ''
Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog