比如,我有如下的一个stored procedurecreate proc [dbo].[zzGetLastVisitDate]
(
@lastVisitDate DateTime output,
@patientID int,
@patientIDClinic char(1),
@date datetime
)
as
begin
SELECT max(date) AS LastDate
FROM Results
WHERE patientID = @patientID
AND patientIDClinic = @patientIDClinic
AND date <= @date;
set @lastVisitDate = ????????? 怎么写这里呀?多谢高手了
end我想用@lastVisitDate 返回select 语句中选择的Date(这里是LastDate), 就是一个单个的值,我该怎么写?多谢了
(
@lastVisitDate DateTime output,
@patientID int,
@patientIDClinic char(1),
@date datetime
)
as
begin
SELECT max(date) AS LastDate
FROM Results
WHERE patientID = @patientID
AND patientIDClinic = @patientIDClinic
AND date <= @date;
set @lastVisitDate = ????????? 怎么写这里呀?多谢高手了
end我想用@lastVisitDate 返回select 语句中选择的Date(这里是LastDate), 就是一个单个的值,我该怎么写?多谢了
如果你一定要输出,那么……将你写出来的东西反过来就可以了set @lastVisitDate =
(SELECT max(date) AS LastDate
FROM Results
WHERE patientID = @patientID
AND patientIDClinic = @patientIDClinic
AND date <= @date)
FROM Results
WHERE patientID = @patientID
AND patientIDClinic = @patientIDClinic
AND date <= @date
(
@lastVisitDate DateTime output,
@patientID int,
@patientIDClinic char(1),
@date datetime
)
as
begin
SELECT @lastVisitDate = max(date)
FROM Results
WHERE patientID = @patientID
AND patientIDClinic = @patientIDClinic
AND date <= @date;end