Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Insert and Update-Trigger

Author  Topic 

gpc44
Starting Member

35 Posts

Posted - 2011-12-13 : 11:27:44
Hi,
I would like to create a trigger for insert and update whenever change the table or a record is added.

Thank You !!


Best Regards
Nicole

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-13 : 11:30:13
start with looking into CREATE TRIGGER syntax below

http://msdn.microsoft.com/en-us/library/ms189799.aspx
make a try first and in case you face any issue we will help

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -