Error in SQL script file

Question

I am working on a database and we are trying to make a script file that will give us the total number of orders in july.

How exactly would I say july because I know syntax is wrong and I would be using sum instead of count right?

Please help, This is what I tried

 use Cis11101_Northwind
 Declare @Julycount int
 Set @Julycount= (Select sum(*) From orders Where OrderDate = 'july')
 print 'The total orders for july is ' + Cast(@JulyCount as varchar)

HaveNoDisplayName · Accepted Answer · 2015-05-05 20:06:47Z

1

You can USE MONTH to get month from the Date. if you want to match with July then MONTH(date) = 7

(Select sum(*) From orders Where MONTH(OrderDate) = 7)

OR

You can use DateName

  (Select sum(*) From orders Where datename(month, OrderDate) = 'July')

edited May 5, 2015 at 20:06

answered May 5, 2015 at 20:01

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in SQL script file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related