Iteratively Perfecting
A Software Developer's notes along the way
Static Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment