• HOME
  • CONTACT

How to: Create trigger for auto update date with SQL Server 2008

2016-03-17 07:01:24

How to: Create trigger for auto update date with SQL Server 2008
Let's try to create a trigger that auto-updates the Trans_Date column in my SQL Server table:


Table Name - Tbl_User_Master
1. UID (PK)
2. UserName
3. UserID
4. Password
5. Trans_date

I have a AFTER Insert trigger to update the Trans_Date column.

Trigger code:

Create TRIGGER Trg_Trans_Date
ON elect.Tbl_UserMaster
After INSERT
AS
update tbl_UserMaster set trans_date = getdate() where UID in (select distinct UID from Inserted)

--amit

Advertisement

ARCHIVES

  • How to: Create trigger for auto update date with SQL Server 2008
  • Gmail gives security error - Sign-in attempt prevented

© 2015 http://blog.sitenxt.com