Question: In SQL SSMS declare a variable of type DATETIME and set it to some value of your choice. Write a query that has a column

In SQL SSMS declare a variable of type DATETIME and set it to some value of your choice. Write a query that has a column for each of the following:

The date 28 days from now (not from the date you set in the variable)

The date 1 year + 1 day from now (not from the date you set in the variable)

How many days between the day and Christmas 2017

The name of the day your date falls on (Wednesday for example)

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!

PLEASE MAKE THIS AS SIMPLE AS POSSIBLE AS I AM NEW TO C#. THANK YOU! Challenge: C# Basics Description: Write a C# console application using .NET Core that utilizes constants, variables, data types,...

Challenge: C# Basics Description: Write a C# console application using .NET Core that utilizes constants, variables, data types, operators, expressions, statements, blocks, and control flow. Purpose:...

Challenge: Swift Basics (in an Xcode Playground) Description: Write a program using an Xcode Swift Playground that utilizes constants, variables, data types, operators, expressions, statements,...

Write the code necessary to do the following inside the Main function of the C# program. Declare the following constants and variables and set their initial values as indicated. Declare a constant of...

Question Write the code necessary to do the following inside the Main function of the C# program. Declare the following constants and variables and set their initial values as indicated. Declare a...

Write a code that respects the code standards of the C++ programming language regarding: Variables and functions names Space use Use of empty lines, Indentation . Your project is assessed based on...

11:10 Search Back Assignment1.docx In Assignment 1, you will design and implement code to (1) display the player ship and the region of space in front of it, (2) move the player ship, and (3) detect...

Please assist as soon as possible!!!! WIll upvote if correct - C programming only (NOT C++) - Refer to the rubric/guidelines - Please ensure the expected output is achieved -Please include the...

Jim McAvoy has prepared the following list of statements about depreciation. 1. Depreciation is a process of asset valuation, not cost allocation. 2. Depreciation provides for the proper matching of...

American Airlines and Air France both schedule nonstop flights from Paris to Philadelphia. Suppose you are choosing which airline to fly based on the one with more consistent flight times for the...

The Stansfield Endowment fund had this performance over the past 4 years: 2 0 1 9 , 2 0 . 0 0 % 2 0 1 8 , 2 5 . 0 0 % 2 0 1 7 , - 3 6 . 0 0 % 2 0 1 6 , 5 0 . 0 0 %

Discuss the policy statement concept and identify three focus areas / procedures where a clearpolicy statement / operating procedure

OUTCOME 2 Identify the types of and reasons for implementing individual incentive plans and discuss under what conditions individual incentives are appropriate.

2. Assume that you are a consultant for a small fastfood retail outlet. What would your suggestions be for key steps in designing a successful incentive plan? Discuss a few recommendations you would...

OUTCOME 3 Indicate the advantage of each of the principal methods used to compensate salespeople.