Newbie Auto Date Column 1

[ironvid]

I need to add a column to automaticly add the date that the record was created.

I am a Complete begineer to sql so the more detail the better,I am using SQL 2000

thanks for any help

regards....stephen

 

[dickiebird]

Read up on Triggers - really is the best way to learn.

Dickie Bird (-)))

 

[hmckillop]

You could set the default value of the column to be getdate()

i.e. if you were creating the table programmatically you would
CREATE TABLE [dbo].[Table1] (
[ID] [int] NOT NULL ,
[MyDateColumn] [datetime] NOT NULL DEFAULT GETDATE()
) ON [PRIMARY]
GO

 

[JamesLean]

Adding a DEFAULT is much better than using a trigger in this scenario. In addition to hmckillop's post, to add a column to an existing table you can use:

ALTER TABLE Table1
ADD CreateDate datetime NOT NULL CONSTRAINT DF_CreateDate DEFAULT (getdate())

--James

 

[ironvid]

(getdate()) IS WHAT I WAS LOOKING FOR

THANKS hmckillop & james