Post reply

The Recomended way (SQL 2005) to handle Default Value on Existing Null Enabled Column

  • November 4, 2008 at 1:39 pm

    #893875

    FYI

    When I design a table, it always contains a datetime created / user created column as well as a datetime altered / user alterd column.

    (the altered columns maintained using a trigger !)

    IMO it is to be considered the minimal audit effort on any object.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • November 4, 2008 at 4:10 pm

    #893947

    ALZDBA (11/4/2008)

    FYI

    When I design a table, it always contains a datetime created / user created column as well as a datetime altered / user alterd column.

    (the altered columns maintained using a trigger !)

    IMO it is to be considered the minimal audit effort on any object.

    Amen to that!

    Now if only I could get you employed at this software vendors development department as the lead so we could start fixing the mess (relationally speaking) that the procedural programmers have generated over the past 10+ years.

    Thanks again!

    Kindest Regards,

    Just say No to Facebook!

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply