34,588
社区成员
发帖
与我相关
我的任务
分享
WHERE CONVERT(varchar(5),dtBirthday,10) = '08-01'
CREATE PROCEDURE UserBirthday_Query
@iMonth INT,
@iDay INT
AS
SELECT UserCode,UserName,dtBirthday FROM [tb_User]
WHERE MONTH(birthday)=@iMonth AND DAY(birthday)=@iDay
MONTH 取月份
DAY 取哪一天