Category Archives: sql

SQL – Default Constraint Table of content The SQL DEFAULT Constraint The SQL DEFAULT Constraint is used to specify the default value for a column of a table. We usually set default value while creating the table. The default values are treated as the column values if no values are provided while inserting the data, […]

SQL – NULL Values Table of content SQL uses the term NULL to represent a non-existent data value in the database. These values are not the same as an empty string or a zero. They don”t hold any space in the database and are used to signify the absence of a value or the unknown […]

SQL – Stored Procedures Table of content SQL Stored Procedures An SQL stored procedure is a group of pre-compiled SQL statements (prepared SQL code) that can be reused by simply calling it whenever needed. It can be used to perform a wide range of database operations such as inserting, updating, or deleting data, generating reports, […]