NULLIF is a function applied to return a NULL value if specified two expressions (expression1= expression2) are equal. NULLIF function is an ANSI function, it is available with other RDBMS vendors like ORACLE, MySQL, Postgres and among others.
NULLIF Function can be useful in cases when applications are using different indicators to represent a Missing or Unknown value which can be transformed to NULL while representing a record in a table.
Concat multiple row values in SQL Server is a well-known familiar problem. Every database developer happened to write concatenation string queries for reporting or general purpose. Numerous methods including XML PATH, COALESCE function, Recursive CTE been used to achieve desired results.
Google assistant totally amazing. Its features are top notch. Google assistant is an artificial intelligence powered virtual assistant developed by Google to aid and assist users to complete tasks and a lot more. In a previous post, I talked about how to activate Google assistant on your Android device, this needs to be done first before moving on to customize your Google assistant. If you are a fan of “tweaking stuff” as I am, then you would love this post. At the end of this post, you will know how to set nickname on Google assistant.
Google photos is a great online photo storage brought to us by Google. You can develop two different kinds of albums using Google Photos website or the mobile application. The first type of album is the new standard album, which only you can see. In case you have the desire of sharing photos to others, then I would advise you create a shared album on Google photos. A shared photo album could be collaborative, meaning others may also be able to include their own personal photos in the album. so, here’s how to easily create an album on Google photos using a mobile app.
Gmail, also known as Google mail is a free advertising-supported email service developed by Google and Gmail has proven to be one of the best mailing services over the years, this can be attributed to its amazing features, wonderful services, and its swift interface. Gmail records about 1 billion+ monthly users, 75% of Gmail users were recorded from mobile devices, thanks to the Gmail mobile app. Gmail has modified its features and design so as to provide better service to users, Gmail has come up with a new design. The new Gmail look is really cool but may not be very user-friendly to some persons, you may have thought of a way to get back your Gmail’s old look, well, I am glad to tell you that your search is over, I will show you how to revert to old Gmail format.
Google is a large community of people that are interested in different things amongst connecting between themselves. It offers a platform where files can be shared as well. If you are a big fan of Google Drive like me, This article is going to show you how to set an expiration date when sharing files on Google drive.
By default, iPhones messages are saved into the phone until you delete them. With the introduction of iOS 11, Apple gives users the option to set iPhone to automatically delete messages to save on storage. If for some reasons you have enabled the auto-delete messages on iPhone, this article will guide you on how to fix iPhone deleting messages by itself.
Over the past few years, automation technology has put a huge impact on almost every industry. With the passage of time, it has become more intelligent and sophisticated – playing a crucial role in improving our daily lives from home to work.
When it comes to computer programs, the automation technology helps us enabling the complex processes. One good example of this is, “Automatic Updates” option in the Windows operating system.
Here goes another article that will show you how to give your Firefox browser have a whole new look and feel. Its cool trust me. In the past we’ve done some articles on changing Google Chrome browser background How To Customize Google Chrome Background you can check it out if you want to know how to change Google Chrome browser background. So, here’s how you can Change Firefox theme with ease.
Did you know that viruses and trojans can get into your PC by means of download? That’s the truth. If you have been a dedicated Google Chrome browser you would agree with me that there are weird moments when you open a website and then comes pop up ads and then a file starts downloading on your PC or Android device without your authorization. Files that download in this manner could be very harmful to your PC. It is advisable to stop automatic downloads on your Google Chrome browser and I will show you how you can do that.
On different forums and blogs, I keep on reading about how scary the new version of Windows is. But, speaking about my experience with Windows 10, I think it is working well and I am really delighted so far.
Hello Face Login, Quick Access in File Explorer, Advanced automatic repair are the few features that really impressed me.
The best thing about this Windows version is, even if your computer crashes two times successively, its Automatic Repair option will run by default. When you will open your computer next time, this automatic repair feature will diagnose the issue and fix it automatically.
Google chrome is ranking as one of the best browsers one can find because of its flexibility, usability, and popularity. It has been proven over time to give better browsing experience for internet surfers and internet lovers. It brings to you personalized news articles, quick link to your favorite site, easy downloads, easy google search and has a built-in translator.
Sometimes, people find it difficult to work on a site in chrome without intermittent intrusion from other sites that were open in other tabs. Sometimes the advertisements they have could come in and disrupt your thought process. Guess what? You can still keep the tab open but shut out the unnecessary interruptions. This can be possible when you mute the website.
