I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. And it wasn’t really a discussion, it was reading a blog and passing back and forth a couple of comments. Regardless. What we talked about was using best practices when coding. Not using *, formatting,…
Year: 2020
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: These are techniques I use all the time. There are almost certainly others. Use what you find works best for you. Debugging stored procedures, functions, even views is something I end up doing quite a…