Chapter 6, Problem 6HOA

A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below.

• Tablename: email_log
• Columns: emailid (numeric), emaildate (datetime), customer# (numeric)
• Primary key: emailid column, define as an Identity Column
• Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected)
• 1. 1. Emaildate = current date, customer# = 1007
  2. 2. Emailid = specify to use the column default value, emaildate = current date, customer# = 1008
  3. 3. Emailid = 25, emaildate = current date, customer# = 1009