Reading Time: 1 minuteChinese/Mandarin holds the most widely spoken language in the world and English trails in third place. In the below tabular you can find Hindi, Bengali & Punjabi which are Indian languages. This figure is based on NationalEncyklopedin So here is the… Continue Reading
Reading Time: 2 minutesIf you have model class and if that needs to be validated we need to explicitly write logic so initial days we were using Data Annotations and this is how code looked like This way programming is good if… Continue Reading
Reading Time: 2 minutesEvery support team may come across once in their career to know about how many connections/sessions are in use. I have compiled the list queries which are specific a database. Microsoft SQL In this sysprocesses is a system table The following… Continue Reading
Reading Time: 1 minuteIn SQL the generic way to count the number records in any SQL database is This works on all the databases but there are other alternates ways to find the number records of a table. Some are much more efficient… Continue Reading
Reading Time: 1 minuteWhat are the various ways of retrieving the shaded part from the below diagram So here are the various of ways of retrieving the result. Every solution mentioned below has its own advantage and disadvantages. Here I have assumed both tables has a… Continue Reading
Reading Time: 4 minutesThe following are the most commonly used joins Inner Joins Right Outer Joins Left Outer Joins Full Outer Joins Before going deeper into the topic For example two table Employee & Department table. So based on this I will explain… Continue Reading