So I am asking this to see if this is something that is even possible within SQL.
I am currently writing up some stored procedures for a VB.Net application I am working on to use to interact with the data within my database.
I am creating a procedure to delete a set of records, but want to know if it's possible for the Procedure itself to sort of ask for confirmation that the item is to be deleted. Something like a message prompt or something where the procedure pauses to wait for further input.
If this isn't doable, I know how I can manage it on the VB.Net side, I am just trying to keep as much of the SQL and database stuff in the database itself as possible.