Create temporary table in SQL Server 2008
Posted on 2011-09-07
Can anybody supply me with some code to create a temporary table in SQL Server 2008 from within Delphi. This table will be used to register follwing fields:
Email Widestring 255
Name Widestring 255
IsSend Bit Default 0
Before sending a mailing all Email-addresses and names will be stored in this temporary table (per user). When the email (newletter) is sent to a certain Email/Name the IsSend-flag will be changed to TRUE.
If the mailing fails for some reason, this table must remain available for the enduser as long as he/she is working with the application. This way the application can try to continue sending.
After all Emails have been send the temporary table will be removed.