which it the solution for that?
Write a stored procedure for Microsoft SQL Server that will accomplish the following: We have a script that runs on the mail server and processes emails that are bounced back to us (incorrect email address, account inactive, etc.). The script will return the email address and the reason the email failed (SMTP code). We then need to use the email address and flag the corresponding account from a database table named 'accounts'. Write a stored procedure that takes as input the following: 1) email address, and 2) SMTP failure code. This stored procedure should then return the following result codes: 1 (account was removed from DB successfully), or 0 (an error occurred and the account was not removed). Here are the DB specifics: DB Name: online_db Affected tables: Table Fields accounts id, name, email, status, smtp_code account_status id, code (where id = 1/code = active), 2/unsubscribed, 3/flagged)
