database stored procedure best practice.

1. always use transaction in data modification query.
2. try to use Try Catch Block to handle errors.