“SET NOCOUNT ON” vs “SET NOCOUNT OFF”

Let’s try this out. First, open your SQL Query Analyzer. Then, run these three lines of code. (I assume your SQL Server 2000 has default Pubs database). Use Pubs SET NOCOUNT ON SELECT au_lname FROM authors Then, change from SET NOCOUNT ON to SET NOCOUNT OFF and run them. Use Pubs SET NOCOUNT OFF SELECT Read more about “SET NOCOUNT ON” vs “SET NOCOUNT OFF”[…]