当我运行显示错误如下 [英] when i run shows error as follows

问题描述

declare @Curmonth  Datetime,
         @curyear Datetime,
         @Start_date varchar(20),
         @Batch_id varchar(20)

 set @curyear = select datepart(year,getdate())  - 5
 set @Curmonth = select datepart(month,getdate()) + 1


select cbm_batch_id, cmn_minor_code,convert(char(12),cbm_batch_start_dt,106) as Start_date
from co_batch_master 
where cmj_major_code = 'REUC' and cbm_active <> 'D' and 
datepart(year,cbm_batch_start_dt) = @curyear and datepart(month,cbm_batch_start_dt) = @Curmonth

当我运行时显示错误如下;

when i run shows error as follows;

Incorrect syntax near the keyword 'select'.
Incorrect syntax near the keyword 'select'.

请帮帮我。



什么是我上面的查询中的错误



Rgds，

Narasiman P

please help me.

what is the mistake in my above query

Rgds,
Narasiman P

推荐答案

修改波纹管块

Modify bellow block

set @curyear = select datepart(year,getdate()) - 5
set @Curmonth = select datepart(month,getdate()) + 1

as

<pre lang="sql">select @curyear=datepart(year,getdate()) - 5
select @Curmonth =  datepart(month,getdate()) + 1</pre>

Hello



问题在这里





设置@curyear = 选择 datepart（年，getdate（）） - 5

设置@Curmonth = 选择 datepart（月，getdate（））+ 1



而不是 < big> 删除datepart中的select





set @curyear = datepart（year，getdate（） ） - 5

设置@Curmonth = datepart（月，getdate（））+ 1





< br $> b $ b







享受编码

Hello

Problem is here


set @curyear = select datepart(year,getdate()) - 5
set @Curmonth = select datepart(month,getdate()) + 1

Instead Of remove the select in datepart


set @curyear = datepart(year,getdate()) - 5
set @Curmonth = datepart(month,getdate()) + 1







Enjoy coding

你好，



首先我会建议年份和月份变量不要使用datetime数据类型，因为它不会给你想要的输出。 。因为2009或20012不是日期时间类型数据..你可以使用smallint年和月..

和第二个当你将任何查询或表达式的输出分配给一个varibale时把它放nside括号（）。



在你的情况下，你可以使用以下线...

Hello ,

first i would recommend that for year and month variables dont use datetime datatype as it will not give you desired output.. as 2009 or 20012 is not a datetime type data.. you can use smallint for year and month..
and second when you assign output of any query or expression to a varibale put it inside parenthesis ().

well in your case you can use below lines..

declare @Curmonth  tinyint,
         @curyear smallint


 set @curyear = datepart(year,getdate())  - 5
 set @Curmonth = datepart(month,getdate()) + 1


select @curyear,@curmonth

< br $> b $ b或

or

declare @Curmonth  tinyint,
         @curyear smallint


 select @curyear = datepart(year,getdate())  - 5
 select @Curmonth = datepart(month,getdate()) + 1

或

or

declare @Curmonth  tinyint,
         @curyear smallint


 set @curyear = (select datepart(year,getdate())  - 5)
 set @Curmonth = (select datepart(month,getdate()) + 1)


select @curyear,@curmonth

这篇关于当我运行显示错误如下的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！