How to use try-catch in trigger
I want to prevent inserting data into a table and return ‘Error’ if ‘OrderDate’ column is greater than ‘2021-01-01’. How can I do this by the use of TRIGGER and TRY…CATCH in sql-server v.2019
I want to prevent inserting data into a table and return ‘Error’ if ‘OrderDate’ column is greater than ‘2021-01-01’. How can I do this by the use of TRIGGER and TRY…CATCH in sql-server v.2019