var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trigger update command
I've created this simple trigger that will insert records into another table when an insert has occurred on another.
CREATE TRIGGER [TG_MYTRIGGER]
INSERT B (date, id)
Select DISTINCT i.date,i.id
from inserted i
What i cant figure out is how to insert the date plus one month into table B
so instead of just inserting into the second table the i.date i want the i.date + one month.
Does anyone know how this could be done.
look at DATEADD in BOL. That will explain it completly.
Breifly, the syntax is: DATEADD(datepart, number, date)