Hi, So your table automatically inserts a timestamp, but hasn't since adding the trigger? Just trying to understand the problem. Is this timestamp the customer_id? Could be that if this gets generated when doing the insert you may not get it. Sounds like you are using an identity field. If that's the case you might want to just use @@Identity, which will give you that value, but you don't need to go to your trigger for that unless there is another reason.
On Thu, 17 Mar 2005 09:45:38 EST, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi all, > > I don't know what possibly can be the reason for not automatically creating > the time stamp when a new record is inserted....this has happened after > creating a trigger which is simpe as below: > > CREATE TRIGGER wc_Insert_Customer ON tblCustomer > FOR INSERT > > AS > > DECLARE @Customer_ID int > SELECT @Customer_ID = Customer_ID FROM inserted > > > > > > > > Yahoo! Groups Sponsor > ADVERTISEMENT > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/Microsofts_C_Sharp/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Microsofts_C_Sharp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
