開發人員遇到一個及其詭異的的SQL性能問題,這段完整SQL語句如下所示:
declare @UserId INT
declare @PSANo VARCHAR(200)
declare @ShipMode VARCHAR(10)
declare @CY_FLAG VARCHAR(1)
declare @PO VARCHAR(20)
declare @BuyerName VARCHAR(100)
declare @Destination VARCHAR(1)
declare @FinalDestination VARCHAR(40)
declare @Factory VARCHAR(10)
declare @NoticeDateStart DATETIME
declare @NoticeDateEnd DATETIME
declare @EELForwarder VARCHAR(100)
declare @SortExPRession VARCHAR(100)
declare @RowIndex INT
declare @PageSize INT
declare @ExistNoticeKey varchar(200)
DECLARE @NULLDATE DATETIME
新聞熱點
疑難解答