Daily Archives: September 23, 2010

Common SQL Server Mistakes – Multi Row DML Triggers

How often have you seen someone write a DML trigger like this: create trigger mytrigger on Mytable for insert as declare @id intselect @id = id from inserted update xx set yyy = zzwhere id = @id return There seems … Continue reading

Posted in Blog | Tagged , , ,