Good Excellent question. Learned quite a bit in the 2nd link (INSTEAD OF trigger).
FYI, in the explanation, it should be the string 'AnotherString' to be replaced with 'Stub', not 'TestString'.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes