sql-server-2005 - 没有从 SQL Server 查询中获得正确的输出

Question

ALTER PROCEDURE [dbo].[Sp_GetEmailForMailing] 
    -- Add the parameters for the stored procedure here
    @end int=1000
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT top(500) RegistrationID, EmailID from dbo.Candidate_RegistrationData
    where status_flag=1 and payment_status=2
    and RegistrationID NOT IN (SELECT top(@end) RegistrationID from dbo.Candidate_RegistrationData
    where status_flag=1 and payment_status=2) order by RegistrationID
END

这是我的存储过程。在此我想要 500 行，但我从 250 行号中获取....任何人都知道为什么会发生这种情况...谢谢

Answer 1

用作 NOT IN 数据源的子查询没有 ORDER BY条款。这样查询引擎就可以随意取TOP(@end)以它认为合适的任何顺序排列。