Author Archives: user

SQL – Auto Increment Table of content The SQL Auto Increment is used to automatically add unique sequential values into a column of a table. We usually define the Auto Increment on a column while creating a table. And when we insert new records into the table, the unique values are added to them. When […]

SQL – Date & Time Table of content SQL provides multiple datatypes and functions to handle Date and Time values in a database. This is because Date and Time values are represented in various formats. For instance, there are two common ways to represent a date value: DD/MM/YYYY and MM/DD/YYYY. Similarly, there is more than […]

SQL – Using Sequences Table of content Sequences in SQL are database objects that generate a sequence of unique integer values. They are frequently used in databases because many applications require that each row in a table must contain unique values and sequences provide an easy way to generate them. Sequences are a feature of […]