What is the use if set nocount on in SQL Server

Question

HI every onecan you explain about this code in sqlSET NOCOUNT ONwhy we write this code in procedurethanks

Mudassar · Accepted Answer

It improves performance by stopping SQL Server calculate number of rows affectedhttpwwwmssqltipscomsqlservertip1226setnocountonimprovessqlserverstoredprocedureperformance

What is the use if set nocount on in SQL Server

Company

Explore

Follow us

Contact Us