none
SQLServer的BUG么? RRS feed

  • 问题

  • 難道這真的是SQLServer的BUG么?

    use xxx
    declare @KeepDay as int
    set @KeepDay = 90

    delete PURCHASEORDERSITEMDETAIL with (rowlock)
    from PURCHASEORDERSITEMDETAIL a(nolock), [NAB2BEDIDBARC].xxx_ARC.dbo.PURCHASEORDERSITEMDETAIL b
            where a.lasteditdt < getdate() -@KeepDay
    and a.[SENDID] = b.[SENDID]
    and a.[RECEID] = b.[RECEID]
    and a.[MESGID] = b.[MESGID]
    and a.[ORDNUM] = b.[ORDNUM]
    and a.[ITMNUM] = b.[ITMNUM]
    and a.[SUBITM] = b.[SUBITM]
    and (exists  (select d.ordnum from asnmain c(nolock),asnitem d(nolock)
            where c.batchno = d.batchno and c.sendid = d.sendid and c.receid = d.receid and c.loadid = d.loadid and c.pallet_id = d.pallet_id
            and c.ackstatus = 'Y'  and d.ordnum=a.ordnum)
            or
         exists  (select e.ordnum from purchaseordersmain e(nolock)
                    where e.lasteditdt < getdate() -@KeepDay
                    and uploadflag = 'F' and e.ordnum=a.ordnum) )

    將上面這段sql語句拿到查詢分析器中檢查語法沒錯,但是一運行就報錯.

    Server: Msg 8624, Level 16, State 1, Line 5
    Internal SQL Server error.

    在網上看到也有人說這個問題 但是好像還是沒解決..

    環境:SQLServer 2000 企業版...2055

    If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
    2010年8月28日 6:52

答案

全部回复