Triggers

[danasegarane]

I want to create a trigger that inserts the current time whenever i insert or update a row automatically. How can I.The two fields are creation_time and modified time. The modified time should be updatee whenever i edit the to rows. The sever is MSSql and my table name is tbl_transaction.

[russell]

CREATE TRIGGER myTrigger
ON myTable
AFTER INSERT, UPDATE
AS

UPDATE myTable
SET modifiedTime = CURRENT_TIMESTAMP
WHERE id = (select id from _INSERTED)
GO


http://msdn2.microsoft.com/en-us/library/ms189799.aspx

[danasegarane]

I want to insert the date only.How can I format the time as dd/mm/yyyy or mm/dd/yyyy

[russell]

Convert(smalldatetime, Left(current_timestamp, 11), 101)

[danasegarane]

Dear Rus ,
I am getting the following error msg

[russell]

sorry, that is a stray underscore. should be inserted not _inserted.

check out BOL for Create Trigger and inserted tables