correctness prompts
9 prompts tagged correctness, drawn from 2 categories. All free to copy, and all editable once they are in your own library.
- Review this diff, correctness firstThe default review pass before you merge anything.Longð Code review & debugging
- Check this query before I run itBefore running anything expensive, destructive, or going into a report.Longð Data & SQL
- Check my aggregation for grouping trapsAny query with GROUP BY that feeds a number someone will act on.Longð Data & SQL
- Hunt every NULL trap in this queryWhen a count came back lower than expected and nothing looks wrong.Longð Data & SQL
- Can any of these joins multiply rows?Totals look inflated and you suspect the join before the data.Shortð Data & SQL
- Where could NULL change this result?A count came back lower than expected and nothing looks wrong.Shortð Data & SQL
- Quick safety check on this queryBefore running anything expensive, destructive, or going straight into a report.Mediumð Data & SQL
- Audit the dates and timezones in this queryNumbers are slightly off and the period boundary is the usual suspect.Mediumð Data & SQL
- Is my GROUP BY lying to me?Any aggregation that feeds a number somebody will act on.Mediumð Data & SQL
Keep the ones you use
Phrasery saves a prompt with a right-click and puts it back the same way, in any text box. Everything here can be added to your own library in one click, then edited to suit how you actually work.
Add to your browser â free