ALTER PROCEDURE [dbo].[MembersActivateAccount]
    @MemberId uniqueidentifier
AS
BEGIN
    -- Should I use this?
    SET NOCOUNT OFF;

    UPDATE [dbo].Members SET accountActive = 1 WHERE id = @MemberId;
    --Or should I SET NOCOUNT ON and use the following line instead?
    --return @@ROWCOUNT;
END

我知道这两个工作，但哪个是更​​好的选择，为什么？

经过一些尝试，我得出结论，SET NOCOUNT在默认情况下关闭存储过程。是否可以在数据库中更改此行为？