Trigger to insert date into table in the form of
instead of SQL standard date format
This allows easily comparing to or updating based on
Oracle date formats or a readable format for the web.
triggername - name of the trigger
TABLENAME - name of the table that trigger is created on
COLUMNNAME - name of column in TABLENAME that will be updated with the output
I use this script to populate a HEADER column in a SQL2005 table and then I can export to a flat file and insert into an Oracle table. I also use this as a user defined function to post a readable date format to the web.
For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.