SQL – Cursors Table of content A database cursor solves the problem of impedance mismatch. It acts as a filter between the result of a SQL query and the statements that process this result. Cursors in SQL A Cursor is a temporary memory that is allocated by the database server at the time of performing […]

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 […]