"Tip 18 : Before you run Update or Delete statement run it as Select statement first" ooh man, I learned this tip the hard way. Again, This is an amazing videos, thanks a lot for sharing these tips
Isn't a CTE though just some sugar syntax for a temp table - which you can also name what you want. Maybe under the hood it has some more efficiencies but I think a temp table may offer some slight additional freedoms also (you can do all sorts of work on it before calling it in a later join, and even have that work interspersed with other work first also. I think CTEs look cleaner and keep the code tidy but I tend to use temp tables and just go wild (Lol).
It's like syntactic sugar for a subquery, rather than a temp table. It's similar to a temp table however there is no database object created. As you mentioned, a temp table has some additional freedoms and you can do more work with them before the main query.
Watching your channel, I realize how many mistakes I made in my old web projects. If I encounter SQL again, I will be many times smarter. Thank you so much! P. S. Only a handful of subscribers for such a useful channel. That's not right.
"Tip 18 : Before you run Update or Delete statement run it as Select statement first"
ooh man, I learned this tip the hard way.
Again, This is an amazing videos, thanks a lot for sharing these tips
Thanks a lot!
Your channel literally changed my life, I am backend I learned sql and database but I found your channel amazing
Thanks a million 😊
Wow thanks for the kind words. I’m glad you like the channel 😊
Isn't a CTE though just some sugar syntax for a temp table - which you can also name what you want. Maybe under the hood it has some more efficiencies but I think a temp table may offer some slight additional freedoms also (you can do all sorts of work on it before calling it in a later join, and even have that work interspersed with other work first also. I think CTEs look cleaner and keep the code tidy but I tend to use temp tables and just go wild (Lol).
It's like syntactic sugar for a subquery, rather than a temp table. It's similar to a temp table however there is no database object created. As you mentioned, a temp table has some additional freedoms and you can do more work with them before the main query.
Nice tips. Thanks for sharing. I have subscribed.
Thanks for the sub!
Watching your channel, I realize how many mistakes I made in my old web projects. If I encounter SQL again, I will be many times smarter. Thank you so much!
P. S. Only a handful of subscribers for such a useful channel. That's not right.
You're welcome! I also wish I knew a lot of these things early in my career.
THANKS FOR THIS RELLY HELPFUL
Glad it helped!
Fantastic Advice!
Glad it was helpful!
Excellent tips. Thank you!
Glad it was helpful!
Great advice, thanks Ben!
No worries!
Thanks for the tips!
You're welcome!
Excellent. Thank you.
You are welcome!
Thanks Ben
No problem!
Tip number 18, I learned the hard way 5 years ago 😢
Oh yeah this tip can definitely be learned the hard way (I've done it too)
THANK YOU BIRO FROM ETHIOPIA ADDIS ABABA
You’re welcome!
Excellent. Thank you.
You’re welcome!