TwitchBot
TwitchBot copied to clipboard
dbo.Broadcaster "LastUpdated" Column Hasn't Been Properly Implemented
No update is being applied to the "LastUpdated" column. Remember to use UTC time.
Look into writing an UPDATE TRIGGER
from the SQL side.
CREATE TRIGGER BroadcasterLastUpdated ON dbo.Broadcaster
AFTER UPDATE
AS
BEGIN
UPDATE dbo.Broadcaster
SET LastUpdated = GETUTCDATE()
FROM dbo.Broadcaster b
INNER JOIN inserted i
ON b.Id = i.Id
END
GO