In sql-server according to syntax, who has to go first: DECLARE or SET NOCOUNT ON? In sql-server according to syntax, who has to go first: DECLARE or SET NOCOUNT ON?
The declare statement will not generate a rowcount message so there is no observable difference between the two.