I have a job that runs sp_refreshview on all views in a database. Once, we dropped a table from the database but forgot to remove the view that was pointing to it. Because of this, the sp_refreshview stored procedure raised an error and everything stopped.
Is there a way to catch this error such that the rest of the query may continue (to refresh the rest of the views)? Thanks.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.