Stored Procedures - Creating

Prompt 1: Create a New Stored Procedure

You are tasked with creating a new stored procedure in a SQL database. The procedure should perform the following task:

Task Description: {task_description}

Generate the SQL code for the stored procedure, including:
- Input parameters
- SQL logic
- Output or return values

Prompt 2: Validate a Stored Procedure

You are validating a stored procedure for correctness and performance. The procedure details are as follows:

Procedure Name: {procedure_name}
Expected Behavior: {expected_behavior}

Generate a checklist to validate the stored procedure, including:
- Syntax correctness
- Performance metrics
- Edge case handling