根据年月来取资料,表里有一个字段是日期,分别取出来匹配,该怎么写?
--------------------------------------------------------------------
这是我写的,不对
ALTER PROCEDURE [DBO].[Prc_GetHomeWorkByMonth]
(
@GroupNO varchar(50),
@NowYear varchar(50),
@NowMonth varchar(50)
)
AS
select a.*,b.groupno,c.Title from SchoolWork a right join SchoolWork_Access b on a.workid=b.workid left join AUTH_GROUP c on b.groupno =c.groupno
where
@NowYear in (select datepart(yy,InputDate) from schoolwork )
and
@NowMonth in (select datepart(m,InputDate) from schoolwork )
and
b.groupno=@GroupNO
ORDER BY a.Deadline DESC
--------------------------------------------------------------------
这是我写的,不对
ALTER PROCEDURE [DBO].[Prc_GetHomeWorkByMonth]
(
@GroupNO varchar(50),
@NowYear varchar(50),
@NowMonth varchar(50)
)
AS
select a.*,b.groupno,c.Title from SchoolWork a right join SchoolWork_Access b on a.workid=b.workid left join AUTH_GROUP c on b.groupno =c.groupno
where
@NowYear in (select datepart(yy,InputDate) from schoolwork )
and
@NowMonth in (select datepart(m,InputDate) from schoolwork )
and
b.groupno=@GroupNO
ORDER BY a.Deadline DESC
解决方案 »
- SQL查询问题
- sql 2表连接 去除重复选项
- 刚买了张sqlserver2000光盘,有四个版。应该装那个版本?
- 两台服务器如何实现相互同步!急
- 数据库中有一字段存在重复,我想查出时间为最后的这个字段,并统计存在多少条这样的记录(题目说的可能不太清楚,帖子内容会补充)
- 寻sql语句~~
- 怎么解决触发器在批量插入数据时失效?
- 关于更新数据库中部分相同记录的字段值
- 前一个问题已经解决,但是还有点小尾巴,请教各位
- 谁配置过windows 2000 server+apache+php+sql server
- SQL联机丛书里的SQL语句,居然有误。批抨MS SQL不负责!
- 分组统计的一个select语句问题
(
@GroupNO varchar(50),
@NowYear varchar(50),
@NowMonth varchar(50)
)
AS
exec('select a.*,b.groupno,c.Title from SchoolWork a right join SchoolWork_Access b on a.workid=b.workid left join AUTH_GROUP c on b.groupno =c.groupno
where
'+@NowYear+' in (select datepart(yy,InputDate) from schoolwork )
and
'+@NowMonth+' in (select datepart(m,InputDate) from schoolwork )
and
b.groupno='+@GroupNO+'
ORDER BY a.Deadline DESC')
select a.*,b.groupno,c.Title from SchoolWork a right join SchoolWork_Access b on a.workid=b.workid left join AUTH_GROUP c on b.groupno =c.groupno
where
datepart(yy,a.InputDate)=@NowYear
and
datepart(m,a.InputDate)=@NowMonth
and
b.groupno=@GroupNO
ALTER PROCEDURE [DBO].[Prc_GetHomeWorkByMonth]
(
@GroupNO varchar(50),
@NowYear varchar(50),
@NowMonth varchar(50)
)
AS
Exec( 'select a.*,b.groupno,c.Title from SchoolWork a right join SchoolWork_Access b on a.workid=b.workid left join AUTH_GROUP c on b.groupno =c.groupno
where
convert(varchar(6),a.InputDate)='''+@NowYear+''+@NowMonth+''' and b.groupno='+@GroupNO+
' ORDER BY a.Deadline DESC')
(
@GroupNO varchar(50),
@NowYear varchar(50),
@NowMonth varchar(50)
)
AS
exec('select a.*,b.groupno,c.Title from SchoolWork a right join SchoolWork_Access b on a.workid=b.workid left join AUTH_GROUP c on b.groupno =c.groupno
where
'+@NowYear+' in (select datepart(yy,InputDate) from schoolwork )
and
'+@NowMonth+' in (select datepart(m,InputDate) from schoolwork )
and
b.groupno='''+@GroupNO+'''
ORDER BY a.Deadline DESC')