What are stored procedures? Pros and cons.

Stored procedures

For What are stored procedures? Pros and cons., interviewers listen for a crisp definition, how the pieces interact in a real system, and one trade-off or failure mode you have seen or would guard against.

• Logic runs inside DB—fewer round trips.
• Harder to version/test vs app code.
• Use for batch ETL or strict data rules close to data.