Question
For AdventureWorks Cycle DB using VisualStudio. database: https://dataedo.com/samples/html/AdventureWorks/ Execute and ALTER the existing user-defined function to return a table with customer information to include more
For AdventureWorks Cycle DB using VisualStudio.
database: https://dataedo.com/samples/html/AdventureWorks/
Execute and ALTER the existing user-defined function to return a table with customer information to include more demographic information.
current function:
CREATE FUNCTION Name_ufnCustomerDemographics RETURNS TABLE AS RETURN
SELECT Customer_ID AS [Customer ID], Customer_Fname AS [First Name], Customer_Lname AS [Last Name], Customer_Phone AS [Phone Number], Customer_Address AS Address FROM Customer
Execute the stored procedure to get top 10 sales records from the Sales Order Detail table.
Create a new stored procedure get top 10 sales records from the Sales Person table.
Create a new stored procedure get top sales records from the Store table.
Execute the existing trigger to add 5 new Products to Product table.
Execute the existing trigger to add 10 new Sales to Sales Order Details table.
Create a trigger to add new Special Offers to the Special Offer table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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