[SQL Server] SET NOCOUNT=ON For Improve Performance in Store Prodedure and Trigger

What is a SET NOCOUNT ON In SQL Server, SET NOCOUNT ON can improve the performance of stored procedures and triggers (In some scenarios) ,In SQL Server SET NOCOUNT ON is used for From Microsoft DocumentationSET NOCOUNT ON prevents the sending of DONEINPROC messages to the client for each statement in a stored procedure. For stored procedures that contain several statements that don’t return much actual data, or for procedures that contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly reduced. Benefits of Using SET NOCOUNT ON Example Usage SET NOCOUNT and @@ROWCOUNT function You can use the @@ROWCOUNT function to get the number of affected rows in SQL Server Reference