I am developing a database for an application. I have to create stored procedure to tables, so that programmers can simply call the stored procedure to implement the functions. I have a doubt to implement the following logic,
For example:
Business Type Table
Stored Procedure
As per my knowledge I thought, this procedure will work fine. While I call the procedure name as follows,
Call businesstype('insert', 1, 'Online Marketing', datetime(),'raj', datetime(), 'raj', 1); Every time needs to call this procedure with all its parameters, but developers need to call the procedure with required fields, for example they need to call only the ID (PK) to perform delete function, but it required some values (NULL) for remaining parameters. How to perform this action? I am just a starter, I am expecting some best practices to implement this, also I need to know whether the given table design and procedure will meet the industry expectations? is it good to implement in this way?
Thanks in advance.