SELECT FileID, Ywgs, FileDate, FileNetWeb, FileOfficeNet, FileEnd FROM dbo.Filedata WHERE (FileNetWeb = '1') AND (FileOfficeNet = '1') AND (FileEnd = '0') AND (FileDate = '2004-5')
--检索符合条件的记录 SELECT @IntCount=Count(*) FROM dbo.Filedata WHERE (FileDate =@IntMonth) AND (FileNetWeb = '1') AND (FileOfficeNet = '1') AND (FileEnd = '0')
---执行条件判断是否有记录 if @IntCount = 0 begin Set @ResultMessage=@IntMonth+'月份的文件还未批阅完!不能月结此月文件。 ' Set @Resultvalue=1 Return(1) end if not @IntCount = 0 begin
在此分别取得下面所符合的条件记录的FileID字段的值再进行判断 SELECT FileID, Ywgs, FileDate, FileNetWeb, FileOfficeNet, FileEnd FROM dbo.Filedata WHERE (FileNetWeb = '1') AND (FileOfficeNet = '1') AND (FileEnd = '0') AND (FileDate = '2004-5')