Iteratively Perfecting
A Software Developer's notes along the way
Static Pages
Posts
SQL Server links
C# Links
HTML5 Links
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment