Working with Sql to query a database is both simple and complex but is an alluring experience for everybody. For the simple requirement it is quite simple and straight forward, but for complex scenarios you have to give a fair amount of thought before finalizing your desired query. Below we’ll walk you through some simple […]
Continue Reading
Problem of duplicate records in databases arises when a table doesn’t have a primary or unique key. Nevertheless, its easy to find duplicate records in the table by using “Group By” and “Having” clauses of SQL query. Group by clause is used to group data based upon one or more columns. In our simple example […]
Continue Reading
Serial numbers are usually required in the very first column of almost every excel sheet. They are the sequence of number normally started from one and incremented by one for each subsequent row, hence providing a unique number to each row. If you’re a regular Excel user and well up in it you may already […]
Continue Reading
While developing in IBM/HCL Notes you may stumble across the situations where your search of documents requires more than one key. The custom function placed below provides you with the same facility. Its prototype is pretty simple, it gets the form name, first field name and its key value, and second field name and its […]
Continue Reading
XML is everywhere, and you can’t (and most probably don’t want to) get rid of it. Pulling in data from heterogeneous technologies in a single well defined and widely accepted data format, that is XML, has made a developer’s life far comfortable than ever. PowerShell makes handling XML quite simple. It converts XML elements to […]
Continue Reading
Windows PowerShell is a robust programming platform which has the capability to cover, by and large, everything a developer can imagine. In this article we’ll articulate a little example to get the weather update through RSS feed. This example uses the PowerShell’s Invoke-RestMethod cmdlet to get weather information from BBC Weather update. Invoke-RestMethod cmdlet pulls […]
Continue Reading
In order to connect to any local area network (LAN), the first thing every computer requires is the Network Adapter or a Network Interface Card. A network interface card is a computer hardware device that connects a computer to a computer network. Below, we’re going to discover almost all information regarding the connected network adapter; […]
Continue Reading
Microsoft Excel provides a very powerful formula language. You can achieve amazing things if you’re well capable of using it. Here’s the calculation of some of the public holidays in USA. You can calculate the rest in the same manner. Place the years in column A. Please refer to the below images taken from the […]
Continue Reading