Solved

Adding a timestamp column to a SQL table.

Posted on 2007-04-04
4
201 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
Comment Utility
>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
Comment Utility
I concur, all date/time/user stamps are usually placed in the last few columns of a table.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now