Microsoft SQL Server is a relational database management system that Microsoft has created. It is a database server, which is a software product whose principal
Apache Impala – Step by Step
Throughout the year, “Big Data & SQL” published a number of articles about Apache Impala. It covers the majority of its features and functions. It’s
HDFS Tutorial
Here are all of the HDFS articles that have been published on this website so far. It’s basically a collection of information organized in a
Apache Pig Tutorial
This page combines all Apache Pig related posts into a single to make it more helpful and beneficial to learners. It is presented in a
Apache Sqoop Course Contents
This page combines all Sqoop-related topics into a single article to make it more helpful and beneficial to learners. It is presented in a hierarchical
Apache Hive Course Contents
Apache Hive is built on top of Apache Hadoop, which is a distributed, fault-tolerant, and open source data warehouse platform for reading, writing, and handling
USE of GO in SQL Server
GO is interpreted by SQL Server utilities as a signal to deliver the current batch of Transact-SQL statements to a SQL Server instance. All statements
Can we convert TIMESTAMP to date time?
The short answer is, NO. Let’s consider the following example. USE testDB GO CREATE TABLE tbOrders ( iOrderID INT IDENTITY(1,1) PRIMARY KEY, dtOrderDate DATETIME, dcPaidAmount
Stored Procedure – RAISERROR
Here’s an example of how to make a user-defined error message and raise it in the event that something goes wrong. — Creating the procedure
MySQLDump Backup and Restore All Databases at once
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
Assign a serial number to result set – MySQL
Concerned parties may occasionally request that a serial number be displayed alongside the result set when a report is being generated. If the table lacks
Generate SubOrder ID to Orders MySQL
To differentiate between OrderIDs that are identical, it is suggested to include a SubOrderID as an additional field with a serial number suffix. For example,
Big Data & SQL 