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)
In 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
If 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
Every 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
In 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
What 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
The 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