set nocount on sql server

Solutions on MaxInterview for set nocount on sql server by the best coders in the world

showing results for - "set nocount on sql server"
Paula
09 Apr 2016
1DECLARE @NOCOUNT VARCHAR(3) = 'OFF';  
2IF ( (512 & @@OPTIONS) = 512 ) SET @NOCOUNT = 'ON';  
3SELECT @NOCOUNT AS NOCOUNT;  
4  
5