Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-04-16 : 02:52:23
|
| i want to make a stored procedure that will update the notification flag in the table. If the email was succesfully sent the flag will be updated as SENT. And if it is un successful the flag will be NOT SENT in column of the table in SQL. The email will be send using .NET codes and updates of notification flag will use SQL stored procedure. Please help |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-04-16 : 03:41:43
|
| [code]CREATE PROCEDURE UpdateEmailStatus ( @EmailID int, @Status varchar(10))AS UPDATE email_table SET Status = @Status WHERE EmailID = @EmailID[/code]--Lumbago |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-04-16 : 05:32:23
|
| Thank you. i will try this |
|
|
|
|
|
|
Update Notification Flag