Developing Operators With Numbers or Variables?
What happens when we want to use a variable throughout code or use a number throughout code in operations? Check out the solution in the video TSQL: Operators With Numbers or Variables. This is one of those issues that depends on debugging, as most developers spend more time debugging code than writing code and we want to think about what saves time relative to the length.
Some discussion points in the video:
- Consider code length ("throughout") and where your choice is placed
- Remember that in troubleshooting, you have to remember what's passed
- Allowing any entry could invite its own issues - see the note about this
For mastering data transformation from one form to another form, check out the highest-rated Automating ETL course on Udemy. For a coupon to the course, check out the trailer video on the channel SQL In Six Minutes.
The good news here is that there is no right or wrong way to write this type of code, except what makes it fast and easy to troubleshoot. Even if we have a variable that was set to 100 and we used it four times, we could just as easily write 100 four times. It's not like it would require more work to use each of the four times and for some it may be faster to troubleshoot without remembering.
Are you looking for tech consultants that can assist with design and development? From building custom applications to working with existing infrastructure that's causing you trouble, we can get you connected to consultants who can assist. You can contact for assistance.