Solved

Adding a timestamp column to a SQL table.

Posted on 2007-04-04
4
206 Views
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.

0
Comment
Question by:vasudharangapathy
4 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 250 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.
0
 
LVL 1

Assisted Solution

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

837 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