• The posts saying if you set SET NOCOUNT ON or SET ROWCOUNT <any value> first is correct, you'll get 0,1 as the answer. unfortunately the question didn't mention anything about it, so 1,1 is what most people would have answered (as shown by the percentage of the chosen answer).

    I got it wrong (chose 1,1) but I don't really care, at least I learn something new! 😛


    Urbis, an urban transformation company