Multiple choice technology databases

When we use SELECT and DML statement in SQL, SQL server returns a message which specify the number of rows effected by these statements. How to disable this?

  1. SET NOCOUNT ON

  2. SET ARITHABORT ON

  3. SET NOCOUNT OFF

  4. SET ARITHABORT OFF
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SET NOCOUNT ON prevents SQL Server from sending the number of rows affected message to the client for each statement. This reduces network traffic and can improve performance for stored procedures with multiple statements. Options B and D relate to ARITHABORT which controls query behavior on arithmetic overflows, and Option C is the opposite of what's needed.

Keep practicing — related questions