Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
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.
Required, but never shown