I am working with volatile tables in stored procedure.
I need to handle errors for drop table X:
a) when table being dropped already exists (from prior run of stored procedure)
b) when table being dropped doesn't exist yet (first run of stored procedure)
I want to drop volatile tables created by sotred procedure, but I cannot find anywhere SQLSTATE values to handle those two errors.
Anyone struggled with this before. This is for voaltile tables....
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.