What are the challenges you face when working across database platforms? Take the survey
Options

Bug with find unused variable and parameters

OzzieOzzie Posts: 46 Bronze 5
When I run 'Find Unused Variables and Parameters' you flag @ID as 'The value here is never used.'
DECLARE
@ID INT = ISNULL( ( SELECT MAX( BatchID ) FROM dbo.RDIBatch ), 1 );

DBCC CHECKIDENT ( RDIBatch, RESEED, @ID );
Tagged:

Comments

Sign In or Register to comment.