Search
Submit a request
Sign in
How can we help you today?
Categories
Submit a request
Submit a request
Sign in
Support
Community
SQL Prompt
Bug with find unused variable and parameters
New post
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 );
Ozzie
August 01, 2017 18:16
-
0
+
Comments
1 comment
Sort by
Date
Votes
Hi @Ozzie,
Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6459) to track it.
Best regards,
Frederico
FredericoJ
August 03, 2017 13:09
-
0
+
Add comment
Please
sign in
to leave a comment.
DECLARE
@ID INT = ISNULL( ( SELECT MAX( BatchID ) FROM dbo.RDIBatch ), 1 );
DBCC CHECKIDENT ( RDIBatch, RESEED, @ID );