Wednesday, January 15, 2020

T-SQL: SET ROWCOUNT 0

Why is this phrase used all over the place in stored procs?  Well, if someone has used "SET ROWCOUNT 1" or to some other number, you need to turn that off! So using "0" turns it off.  It does not set the rowcount to ZERO!!!

No comments: