wut - Came across a gem today...part of a stored procedure that sits under our erp software. This explains a lot - devRant

Ranter

Comments

0

IntrusionCM

14956

5y

SET @@ShowDetail = @ShowDetail ?
2

ArcaneEye

653

5y

... and if it's 0!?
4

soohoonigan

280

5y

@ArcaneEye I should finish it with "else set @showdetail = 0" and leave it for the next dev who comes across it
1

IntrusionCM

14956

5y

@soohoonigan lol. I would never have guessed that it wasn't initialized to 0...
3

NoToJavaScript

4646

5y

Not an expert. But won’t this assign force a query plan recompile? If yes, it may be intentional. We are fighting query plans daily, my go to solution is “Optimize for unknown” and in some cases “option recompile”
1

sadgrad19

86

5y

But what is @showdetail? 0_0

What r u showing
Who r u showing
Where
Who is detail
2

c3r38r170

3769

5y

@sadgrad19 Whatever it is, it already is itself.

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service