Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

set nocount on sql

SET NOCOUNT OFF – By default, SQL Server shows the number of affected rows in the messages pane
SET NOCOUNT ON – We can specify this set statement at the beginning of the statement. Once we enable it, we do not get the number of affected rows in the output
Source by www.sqlshack.com #
 
PREVIOUS NEXT
Tagged: #set #nocount #sql
ADD COMMENT
Topic
Name
6+1 =