Got it — stored procedures are your target

You want to provide natural-language requirements and receive stored procedures as the output. Good — we’ll focus on mapping requirements to procedure structure and on generating tested, deployable SQL procedures.

Match requirement parts to stored procedure components

Below are common requirement snippets you might give as prompts. Match each snippet to the stored-procedure component it primarily relates to.

Drag the best-matching component for each requirement snippet.Accept a customer ID and return their active subscriptionsEnsure no duplicates are created when inserting new ordersIf an update fails, roll back all related changesReturn a status code and a message describing the operation result

If you were giving a natural-language requirement for a stored procedure now, write one concise sentence (one line).

How was this question?

Too easyAbout rightToo hard

Learning: Learn sql coding with Gitlab duo AI