Quote:
is it the good to write all business logic in stored procedure??
I doubt that you're able to write all business logic in a single stored procedure. But yes, using stored procedures for
CRUD[
^] operations is very well and common used practice. For example, you can create separate stored procedure for:
1. READ
2. CREATE/UPDATE
3. DELETE
or
1. READ
2. CREATE
3. UPDATE
4. DELETE
The choice is yours!
Good luck!