Temporary tables, as the name implies, are used to temporarily store data. These tables can be used for CRUD (Create, Read, Update, and Delete), join,
Category: RDBMS
Common Table Expressions (CTE) in SQL Server
A common table expression (CTE) is a named temporary result set that may be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. A CTE
Temporary Objects in SQL Server
Many temporary objects are employed in the day-to-day transactions of medium or large OLTP databases. These objects can be temporary tables, temporary variables, session variables,
Default Constraint – SQL Server
The DEFAULT constraint is used to provide a column’s default value. If no alternative value is supplied, that is, if the user leaves the column
Entity Integrity
Entity Integrity ensures that the table contains no duplicate records and that the field that identifies each entry is distinct and never null. The Primary
Data Retrieval in SQL Server
We obtain data from SQL Server tables using the SELECT command, but this command is insufficient because we are not expected to receive the entire
Big Data & SQL 