I want to create a website that is able to post automatically a payment confirmation code to cells in a simple spreadsheet format. This would be retrieved from an email that both the payer and payee receive as acknowledgement. At this point I do this manually. If volume were to begin to escalate that might become quite difficult to keep current. Is using an SQL database the best avenue to accomplish this?
You could do this with SQL Server, but - depending on how you need to implement it - you'll have to do some scripting. It might be easier to use an web page with some code behind it to do what you want.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at: