Adding a timestamp column to a SQL table.

Posted on 2007-04-04
Medium Priority
Last Modified: 2010-03-20
Is there a recommendation on whether to add a timestamp column on the beginning or end of the table?
Does it matter where the column is added.

Question by:vasudharangapathy
LVL 61

Accepted Solution

mbizup earned 1000 total points
ID: 18850796
>Does it matter where the column is added.
The order doesn't matter.  I keep timestamp, created by and modified by information in the last columns of my table-- just for consistency's sake.

Assisted Solution

CraigDerington earned 1000 total points
ID: 18960956
I concur, all date/time/user stamps are usually placed in the last few columns of a table.

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question