Dynamic Stored procedure

Hello!Greetings! I’m a learner of oop and pdo in php.
Now I’m trying to learn stored procedures.

In my site, I made a CRUD statement in my table user using stored procedure and I’m flattered, works well.
But something is bothering me. If I have many tables, do I need to make a CRUD statement each table? I’m thinking of
OOP in stored procedure. Is that possible or is there a thing such that?
I’m new in stored procedure and I’m using SQL Server 2012 R2.

any advice will help. thank you.