Please support our MS SQL advertiser: Programming Forums
Views: 2172 | Replies: 1
•
•
Join Date: Mar 2007
Posts: 34
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
hi..
i'm having a table called "Survey". Whenever user create survey, it will store the date and time the survey was created.
right now..all the survey created by user are the the same for each record..
i guess i shouldn't use getdate()
what should i do to resolve this?
please help...
i'm having a table called "Survey". Whenever user create survey, it will store the date and time the survey was created.
CREATE TABLE [dbo].[Survey] (
[CustomerID] [int] NOT NULL ,
[SurveyID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DateCreated] AS (getdate()) ,
[coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]right now..all the survey created by user are the the same for each record..
i guess i shouldn't use getdate()
what should i do to resolve this?
please help...
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode