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.
| Author |
Topic |
|
peterpan23
Starting Member
3 Posts |
 Posted - 2009-09-28 : 08:58:53
|
| i am new here and not very experienced in the whole db-area. so please dont flame me :) i need to create a new trigger for my table. its about documents, my trigger should set a value to 1 whenever 1 type of a document gets inserted. values of the table (everything as an example)Date, DokType, Locked (1/0), Creater and so on all the inserts are going with a 0 on the Locked field, but the trigger should put it to 1 whenever a DokType 'RG' comes in. can some1 help me? i tryed out google and and some examples i found out but it didnt work out..or i understood it wrong. regards from switzerland |
|
|
|
|
|
simple trigger