The system function @@ROWCOUNT is used to return the number of rows that were impacted by the last statement that was executed. The number of
Category: SQL Server
It’s all about TempDB
Temporary user objects that are specifically created are stored in the tempdb system database, which is a global resource. They consist of temporary stored procedures,
DEFAULT CONSTRAINT for DATES
Default dates in legacy systems, particularly MySQL, were set to 0000-00-00. From version 5.6 on, MySQL stopped allowing users to enter these values without first
Apache Impala – Data Analysis – Problem Scenario-1
One of the problem scenarios that can aid in analytical thought and problem-solving is shown below. SQL Server, MySQL, any RDBMS product, Apache Hive, Apache
SQL Server – Sample Schema – Tables – For Practice
Beginners can practice creating new tables, joining them together, using sub-queries, etc. with the schema below. I hope this will be useful to you as
UNIQUE KEY in SQL Server
This article’s goal is to add to “SQL Server All in One.” The use of a unique constraint makes sure that no duplicate values are
Big Data & SQL 