locked
using ent lib, does it mean that stored procedure can never use set nocount on? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1215150307 posted

    using ent lib, does it mean that stored procedure can never use set nocount on?

    Wednesday, August 3, 2011 3:10 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-837620913 posted

    You can set NOCOUNT on in a stored procedure when using Enterprise Library, it will just return -1 for the number of records affected by the stored procedure.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 3, 2011 5:15 AM