Nice example for juniors, however i stronly agree with Rune Birvin about the select * in a view. If the underlying structure changes that could result in invalid or unpredictible results.
Furthermore I suggest to always use the sysname type for SQL objects.
Kind regards,
Hans