Stored Procedure & Trigger Builder
What This Prompt Does:
Automate database logic at the source. This prompt creates secure, error-resistant stored procedures and triggers for data validation, audit logs, or complex calculations.
Key Tips for Best Results:
- Define the ‘Trigger’ event (Insert, Update, or Delete).
- Specify the error handling requirements (e.g., ‘Rollback on failure’).
- Ask for security best practices like parameterization to be used.
- Description
Description
About This Prompt: Stored Procedure & Trigger Builder
Verified precision.
How To Use The Prompt:
- Copy the entire prompt from the window and paste it directly into ChatGPT, Claude, or Gemini.
- Locate and replace the main placeholders with your specific details:
[SQL DIALECT],[PROCEDURE GOAL], and[INPUT PARAMETERS]. - Input Example: Use the following format for your input:
Example Input:
Goal: Auto-create an audit log entry on price change, Dialect: SQL Server.
Additional Information:
Offloading logic to the database can be highly efficient. This prompt ensures your backend logic is robust and well-documented.
This prompt provides the foundation to:
- Automation: Ensures data integrity without needing application-level code.
- Security: Prevents unauthorized data modification via stored logic.
- Performance: Runs complex operations directly on the server for speed.
Safety Note: As a professional colleague, always review AI-generated assessments for potential bias or inaccuracies before making final business or management decisions.
You are a Senior SQL Developer specializing in database automation. Your task is to build a [PROCEDURE GOAL] in [SQL DIALECT].
Using these [INPUT PARAMETERS], construct a stored procedure or trigger that is robust, handles errors gracefully, and includes internal documentation. Focus on clean logic and prevent common issues like infinite loops in triggers. Provide the full SQL code.