SQL Server procedure read_stream_sub has variable @from_position BIGINT
- StreamPosition is an INT
- @from_position is a BIGINT
The WHERE clause is comparing these two value: StreamPosition >= @from_position
This is generating a code smell when I build this project with static code analysis enabled:
SqlServer.Rules : Data types on both sides of an equality check should be the same in the where clause. (Sargable) (https://github.com/ErikEJ/SqlServer.Rules/blob/master/docs/Performance/SRP0016.md)
SQL Server procedure read_stream_sub has variable
@from_position BIGINTThe WHERE clause is comparing these two value:
StreamPosition >= @from_positionThis is generating a code smell when I build this project with static code analysis enabled: