CREATE PROCEDURE proc_getWorkingHourOfADay(@employID varchar(10))
AS
SELECT MK012 AS WorkingHourOfADay FROM PALMK WHERE(MK001=(SELECT MV027 FROM CMSMV WHERE (MV001=@employID))) GO
原文转自:http://www.ltesting.net