ZealUps
Menu Close
  • Home

SQL

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)

0

Include Metadata in DB Objects

Posted on February 23, 2017 by shiljo

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 →

Programming Microsoft SQL, SQL
0

How to get recently created & modified DB Objects

Posted on July 4, 2016 by shiljo

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 →

Programming Microsoft SQL, SQL
0

Query to know Process, Connection & Session of a DB

Posted on January 23, 2016 by shiljo
SQL Connections & Sessions

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 →

Programming Microsoft SQL, Oracle, SQL
0

Alternate ways to Count the Number of Records in SQL

Posted on January 20, 2016 by shiljo
Count(*) Alternates

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 →

Programming SQL
0

SQL Puzzle – 1

Posted on January 20, 2016 by shiljo
SQL Problem

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 →

Programming SQL, SQL Joins
0

SQL Joins

Posted on January 20, 2016 by shiljo

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 →

Programming SQL, SQL Joins

Categories

  • Language (2)
  • Mathematics (5)
  • Nutrition (6)
  • Programming (34)
  • Software (2)
  • Travel (1)

Archives

© 2021 ZealUps. All rights reserved.
Hiero by aThemes