Dynamic SQL is a programming approach that allows you to create SQL statements at runtime. Because the whole wording of an SQL statement may be
Table Variables in SQL Server
Table variables, like temp tables, are used to temporarily store data. This functions as a variable and is only present for a specific batch of
Temporary Tables in SQL Server
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,
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,
Individual databases to customers
” I love my family, my wife and I share almost everything. We have been known to end each others sentences, and when times were
Big Data & SQL 