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