Posted on 2009-02-16 14:13
非洲小白臉 閱讀(330)
評(píng)論(0) 編輯 收藏 所屬分類:
其他資源
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE sp****(
@a AS VARCHAR(3),
@b AS VARCHAR(7),
@c AS CHAR(2),
@d AS VARCHAR(7)
) AS
BEGIN
DECLARE @NDTime varchar(50)
DECLARE @aOD VARCHAR(8)
DECLARE @dateDif INT
DECLARE @JRC VARCHAR(1)
/* 現(xiàn)在日時(shí)取得SP(sp****NowDate)を使用して、日時(shí)を取得する。 */
EXEC sp****NowDate @NDTime OUTPUT
SELECT @aOD = 字段
FROM ****
WHERE 字段 = @a
AND 字段 = @b
AND 字段 = @c
AND 字段 = d
SET @JRC= '1'
if datediff(d,Convert(datetime,@aOD),Convert(datetime,@NDT)) >= 180 begin
SET @JRC = '0'
end
SELECT @JRC ****
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO