I have a trigger set on the Date feild in the Action Table. I need to be able to add a different date if the user supplies one. How can I still keep this trigger? Or do I have to remove it and add the current date manually every time.
CREATE TRIGGER [Action Date] ON [db129981905].[dbo129981905].[Actions]
FOR INSERT, UPDATE
SET DATEFORMAT mdy
Set ActionDate = GetDate()
Where ActionID = @@Identity