For AdventureWorks Cycle DB using VisualStudio.

Create a stored procedure to return Sales Order records:

One to get sales records from the Sales Order Detail table

One ALTER procedure to add a Sales Date prompt

Create a trigger to add new Products to the Product table.

Create a trigger to add new Sales to the Sales Order Details table.

database: https://dataedo.com/samples/html/AdventureWorks/