▲ 3 r/SQLServer
When do you use set rowcount instead of top?
Yesterday stumbled upon code at work - at the end of many SPs were set rowcount 0 despite it never being assigned before.
From quick googling, I found that Microsoft deprecates it for everything except select, but I am not sure why would you use it for select if top out there doing seemingly the same thing?
u/elephant_ua — 2 days ago