While you might have several years of experience using computers, there are yet numerous ways to sharpen your skills on the PC and boost your productivity. These small yet impactful tips and tricks can not only help you streamline your tasks but also save you considerable time and efforts hence significantly enhance your productivity. […]
Continue Reading
A mouse is one of the most common devices that every computer user uses and it has been widely used even before the advent of mobile phones. Even the little children know how to use it to serve their purpose. But in this article we will highlight some extremely useful mouse tricks that most […]
Continue Reading
In the vast landscape of feature-rich Windows 10, there exist numerous features and functionalities that often go unnoticed or underutilized by the users. Despite a zillion of tools and features at our disposal, certain gems remain hidden, waiting to be discovered for enhanced productivity and unique functionality. In this article, we shed a spotlight […]
Continue Reading
In the realm of Windows navigation and efficiency, a few simple tricks can make a world of difference in how users interact with their computers. With the provision of zillions of features and tools by the operating system, discovering quick-access shortcuts to commonly used ones can enhance productivity. In this article, we delve into […]
Continue Reading
♥ – Alt + 3○ – Alt + 9♫ – Alt + 14™ – Alt + 0153© – Alt + 0169® – Alt + 0174α – Alt + 224ß – Alt + 225π – Alt + 227Σ – Alt + 228µ – Alt + 230≡ – Alt + 240± – Alt + 241Σ – Alt […]
Continue Reading
WiFi – Wireless FidelityWWW – World Wide WebHTTP – Hyper Text Transfer ProtocolGIF – Graphics Interchange FormatJPEG – Joint Photographic Experts GroupHTML – Hyper Text Markup LanguageURL – Uniform Resource Locator ISP – Internet Service ProviderGPS – Global Positioning SystemSQL – Structured Query LanguageSMS – Short Message ServicePDF – Portable Document FormatCCTV – Closed Circuit […]
Continue Reading
HCL Notes doesn’t provide a direct way of working with a master-details scenario, may be because it’s not a relational database system where Primary-Foreign-Key relationship entails the designer platform to provide some efficient mechanism to entertain this particular scenario. So we need to devise some alternate methodology to achieve it. So in order to […]
Continue Reading
In a previous article we learnt how to use CTE (Common Table Expression) to render dates in a date range. In this example we’ll use somewhat advance technique to show a data in a heirarchical form. Using the regular T-SQL query this is almost impossible to achieve it without coding in a strored procedure […]
Continue Reading
Using a traditional programming language like C# or Python you can use “for” and “while” loop constructs to generate a sequence of numbers, dates, string values or anything else super-easily. But here we’ll learn how to generate date values in a specific range using Transact-SQL query. We’ll not use any SQL stored procedure. Let’s […]
Continue Reading
There are occasions when it is required to reveal running totals before rendering the grand total in a report. Usually calculating and providing running total is the job of a report designer software module. But if you’re using SQL Server database then Transact-SQL (a.k.a T-SQL) provides this facility right in the query. Let’s assume […]
Continue Reading