A long, long time ago, ORDER BY in a view meant something. People still think so. Read why…

Tip : Checking for potential constraint violations before entering SQL Server TRY and CATCH logic