sql生日问题
Employee表有EID，birthday列
知道今天getdate()，求下一星期那个员工过生日。写成表值函数的（或标量也行~~）形式，
考虑跨年的问题。我有个思路：if（这个星期跨年）else （不考虑跨年的）
SQL code:
create table Employee( EID int,birthday datetime)
insert Employee select 1,'2009-01-11'
union select 2 ,'2009-02-01'
go
create function f_ddd(@b datetime,@cd datetime)
returns datetime
as
begin
declare @d datetime
set @d = dateadd(yy,datediff(yy,@b,@cd),@b)
set @d = DATEADD(wk, DATEDIFF(wk,0,@d), 0)+7
return @d
end
go
select *
from Employee
where datepart(wk, getdate() )+1=datepart(wk, dbo.f_ddd (birthday,getdate()))
drop function f_ddd
drop table Employee
EID birthday
----------- ------------------------------------------------------
1 2009-01-11 00:00:00.000
（所影响的行数为 1 行）
上面错了，这个
SQL code:
create table Employee( EID int,birthday datetime)
insert Employee select 1,'2009-01-18'
union select 2 ,'2009-02-01'
go
select *
from Employee
where datepart(wk, DATEADD(wk, DATEDIFF(wk,0,getdate()),0)+7) =datepart(wk, dateadd(yy,datediff(yy,birthday,getdate()),birthday))
drop
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
姓名</td>
......
