查詢篇-如何查指定日期內(nèi)生日學(xué)員？-麥田軟件

【相關(guān)代碼】

SQL版

Select
StudentID as 學(xué)號(hào),
StudentName as 姓名,
Student.Sex as 性別,
Student.Birthday as 出生日期,
Student.SchoolID as 校區(qū)編號(hào),
Student.SchoolName as 校區(qū)名稱,
Student.Tel as 電話,
Student.MobileTel as 手機(jī)
from Student
where Birthday is not null
and Datepart(month, Birthday) >=Datepart(month, {@StartDate:開(kāi)始日期})
and Datepart(month, Birthday) <= Datepart(month, {@EndDate:結(jié)束日期})
and Datepart(day, Birthday) >= Datepart(day, {@StartDate:開(kāi)始日期})
and Datepart(day, Birthday) <= Datepart(day, {@EndDate:結(jié)束日期})
and Student.SchoolID in ( {@SchoolID:校區(qū)})

Acess版

Select
StudentID as 學(xué)號(hào),
StudentName as 姓名,
Student.Sex as 性別,
Student.Birthday as 出生日期,
Student.SchoolID as 校區(qū)編號(hào),
Student.SchoolName as 校區(qū)名稱,
Student.Tel as 電話,
Student.MobileTel as 手機(jī)
from Student
where Birthday is not null
and Datepart('d', Birthday) >=Datepart('d', {@StartDate:開(kāi)始日期})
and Datepart('d', Birthday) <= Datepart('d', {@EndDate:結(jié)束日期})
and Datepart('M', Birthday) >= Datepart('M', {@StartDate:開(kāi)始日期})
and Datepart('M', Birthday) <= Datepart('M', {@EndDate:結(jié)束日期})
and Student.SchoolID in ( {@SchoolID:校區(qū)})

在應(yīng)用市場(chǎng)里找到這條然后點(diǎn)安裝就可以了。SQL版編號(hào)為101，AC版編號(hào)為102，安裝好以后在編輯授權(quán)一下就可以了。