27,579
社区成员
发帖
与我相关
我的任务
分享
DATEADD(Day,[SupportDate],'2009/04/08'),
DATEADD(Day,[SupportDate],cast('2009/04/08' as datetime))
select dateadd(day,20,getdate())
INSERT INTO
T_MedCoachSub_Keizoku
([MedCoachID],
[MedCoachPatternDiv],
[FinishFlag],
[SupportDate], --DATETIME型
[SupportType],
[SupportTimeMinutes],
[SupportPoint],
[SupportStaffDiv],
[Memo],
StatusFlag,
LastUpDateTime,
LastStaffID
)
SELECT
'11',
[MedCoachPatternDiv],
0,
DATEADD(Day,cast([SupportDate] as datetime),2009/04/08), --[SupportDate] int型
[SupportType] ,
[SupportTimeMinutes] ,
[SupportPoint] ,
[SupportStaffDiv] ,
[Memo] ,
0,
'2009/04/09 10:04:39',
'1'
FROM [M_MedCoachCourseSub]
WHERE [MedCoachCourseNo]=2