The CASE expression is frequently used in day-to-day tasks, particularly when preparing reports and conducting data analyses. It analyzes a set of conditions and provides
Category: SQL Server
SQL Server Administration, Development and Maintenance
@@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT
The @@IDENTITY, SCOPE IDENTITY(), and IDENT_CURRENT functions all return the Identity value (ID value) of the recently (latest) inserted record, however, there is a distinction
AUTO UPDATE THE DEFAULT DATE in SQL Server
In a previous post, it was explained how to update the default date or date column in MySQL when a row gets updated. The clause
Answers – Problem Scenarios for Practice
Please refer to the SQL practice questions here. Answers to those problem scenarios are given below. Answer to Problem Scenario # 1 UPDATE tbOrdersTickets SET
SQL Server – Problem Scenarios for Practice
There is no denying that practice is a key factor in students developing subject-matter knowledge. Really, practice is essential to maximize the impact of training.
SQL Server Training
Some argue that “..relational databases are out of date and do not match current trends..”, while others contend that “..SQL cannot handle big data..” and “..SQL cannot handle unstructured data..”. There
Big Data & SQL 