Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Execute a query to check if a corresponding record has been inserted into the [Sales].[OrderAudit] table. The AuditTimestamp in [Sales].[OrderAudit] should be the current date
Execute a query to check if a corresponding record has been inserted into the [Sales].[OrderAudit] table.
The AuditTimestamp in [Sales].[OrderAudit] should be the current date and time.
OrderDetails (Sales) orderid productid unitprice qty discount Products (Production) productid productname supplierid categoryid unitprice discontinued Categories (Production) categoryid categoryname description Suppliers (Production) supplierid companyname contactname contacttitle address city region postalcode country phone fax Cu Employees (HR) empid lastname firstname title titleofcourtesy birthdate hiredatel address city region postalcode country phone mgrid 8 Orders (Sales) orderid custid empid orderdate requireddate shippeddate shipperid freight shipname shipaddress shipcity shipregion shippostalcode shipcountry Customers (Sales) custid companyname contactname contacttitle address city region postalcode country phone fax Shippers (Sales) shipperid companyname phone OrderDetails (Sales) orderid productid unitprice qty discount Products (Production) productid productname supplierid categoryid unitprice discontinued Categories (Production) categoryid categoryname description Suppliers (Production) supplierid companyname contactname contacttitle address city region postalcode country phone fax Cu Employees (HR) empid lastname firstname title titleofcourtesy birthdate hiredatel address city region postalcode country phone mgrid 8 Orders (Sales) orderid custid empid orderdate requireddate shippeddate shipperid freight shipname shipaddress shipcity shipregion shippostalcode shipcountry Customers (Sales) custid companyname contactname contacttitle address city region postalcode country phone fax Shippers (Sales) shipperid companyname phone
Step by Step Solution
★★★★★
3.26 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
Here are the SQL scripts for each of the tasks youve described Task 1 Create OrderAudit Table and Trigger 1 Create the SalesOrderAudit table CREATE TABLE SalesOrderAudit AuditID int IDENTITY1 1 PRIMAR...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started