CREATE PROCEDURE GetDailyDutyID
@InPut1 varchar(16),@InPut2 varchar(16),@InPut3 varchar(16)
AS
select DutyID from DailyDuty where EmployeeID=@Input1 and LoginTime>=@Input2 and LogOutTime<=@Input3
GO
我写了执行的语句
EXECUTE GetDailyDutyID '1','07/07/12','07/07/13'
GO
结果显示不出来,我在区域里面选择的YY/MM/DD
数据库里面有一个符合条件的数据请高手指点
@InPut1 varchar(16),@InPut2 varchar(16),@InPut3 varchar(16)
AS
select DutyID from DailyDuty where EmployeeID=@Input1 and LoginTime>=@Input2 and LogOutTime<=@Input3
GO
我写了执行的语句
EXECUTE GetDailyDutyID '1','07/07/12','07/07/13'
GO
结果显示不出来,我在区域里面选择的YY/MM/DD
数据库里面有一个符合条件的数据请高手指点
@InPut1 varchar(16),@InPut2 varchar(10),@InPut3 varchar(10)
AS
select DutyID from DailyDuty where EmployeeID=@Input1 and LoginTime>=@Input2 and LogOutTime<=@Input3
GO
我写了执行的语句
EXECUTE GetDailyDutyID '1','2007-07-12','2007-07-13'
GO试试
select DutyID from DailyDuty where EmployeeID='1' and LoginTime>='07/07/12' and LogOutTime<='07/07/13'
這條語句可以得到結果?
(
@InPut1 varchar(16),
@InPut2 datetime,
@InPut3 datetime
)
AS
select DutyID from DailyDuty where EmployeeID=@Input1 and LoginTime>=@Input2 and LogOutTime<=@Input3EXECUTE GetDailyDutyID '1','2007-07-12','2007-07-13'
select DutyID from DailyDuty
where EmployeeID=1 and LoginTime>='2007-07-12' and LogOutTime<='2007-07-13'