Mostly review for me, but the very last item was new to me. I've always encoded a special value for 'all'. I will explore how i can use NULL instead. Thanks very much.
In the end it doesn't make a huge difference if you use a special value or NULL. NULL is handy though, because you can apply standard rules for all filter criteria controls then.
I appreciate the way you explained how this works. I also liked your use of the "SQL Editor" tool. I've made one myself and added SQL syntax highlighting to it. I'm curious if you have an interest in working together on it.
Hello Philip and Ben, I am very interested how you made this sql editor and the syntax highlight function combined. I had a nice tool in the past which I can no longer use on my new laptop because it was 32 bit. This solution will help me to quickly analyze the data. Next to the highlight I would like to add indents as well.
Great refresher. I struggled with Unions long ago and just left them out. You also gave me insight how to use the Northwinds database. Bravo!
Mostly review for me, but the very last item was new to me. I've always encoded a special value for 'all'. I will explore how i can use NULL instead. Thanks very much.
In the end it doesn't make a huge difference if you use a special value or NULL. NULL is handy though, because you can apply standard rules for all filter criteria controls then.
Hi Sir.
You are amazing.... Thanks a lot for your knowledge Sharing.
I am learning a lot with you...
A big hug.
From Portugal.
Paulo
Simple explanation for beginners. 👍
I appreciate the way you explained how this works. I also liked your use of the "SQL Editor" tool. I've made one myself and added SQL syntax highlighting to it. I'm curious if you have an interest in working together on it.
Hello Philip and Ben, I am very interested how you made this sql editor and the syntax highlight function combined. I had a nice tool in the past which I can no longer use on my new laptop because it was 32 bit. This solution will help me to quickly analyze the data. Next to the highlight I would like to add indents as well.
I found also this only cannot understand the language, ua-cam.com/video/6YI8qi-YXBk/v-deo.html