For simple CRUD operations I would imagine most developers these days would favour an ORM framework over inline SQL or stored procedures, then use SP's for more complex queries/reports (from what I have seen over the past few years anyway).