Question: convert anonymous block to a stored procedure that will accept a date as input and print the original date, the date after one year, week

convert anonymous block to a stored procedure that will accept a dateconvert anonymous block to a stored procedure that will accept a date as input and print the original date, the date after one year, week and day. Execute your stored procedure. Examples of execution.

2. Must be completed and tested or -2 points (not graded, used to prepare you for graded DECLARE Qdate DATETIME SET @date- getdateO; -- set @date as current date SELECT @date as 'Current Date', display current date assignment #3) Run the following T-SOL code DATEADD(year, 1, Qdate) AS 'Plus one Year', DATEADD (week, 1, adate) AS Plus one week', DATEADD(day, 1, Qdate) AS 'Plus one Day' Modify code: convert anonymous block to a stored procedure that will accept a date as input and print the original date, the date after one year, week and day Execute your stored procedure. Examples of e xecutiorn declare ia datetime SET @a getdate(); exec date procedure a SET @a =CAST(' 10-JAN-2017' as datetime); exec date presedure @a; 100 % Messages Original date Jan 12 2015 4:47PM A year later Jan 12 2016 4:47PM A week later Jan 19 2015 4:47PM A day later Jan 13 2015 4:47PM Original date Jan 10 2017 12:00AM A year later Jan 10 2018 12:00AM A week later Jan 17 2017 12:00AM A day later Jan 11 2017 12:00AM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!