Structured Query Language (SQL) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS)
Reading Time: 2 minutesIn case if you want to include extended properties to the database objects you can use sp_addextendedproperty of SQL Server. Which comes handy incase if you want to include Description for a column/table/any db objects. Suppose if I have table… Continue Reading
Reading Time: 1 minuteIf you are software tester or a software developer and if you want to know which objects are recently created or modified then here is the query You can add filters/where conditions if you want specifics example you can include… 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