In my earlier essay, I discussed SQL Server’s error handling in great detail. This is a follow-up post; it discusses RAISERROR, which produces an error
Error Handling – Introduction
In SQL Server, error handling (also known as exception handling) offers us control over the Transact-SQL code and aids in diagnosing the precise point where
LOAD DATA INFILE – MySQL – Errors
Rows from a text file are quickly read into a table using the LOAD DATA statement. Depending on whether the LOCAL modifier is specified, the
FULL OUTER JOINS in MySQL?
The SQL FULL OUTER JOIN combines two tables based on a common column and chooses records from both tables that match the values of the
Using a User Defined Function while adding a column
I tried to figure out how to add the computation expression for a computed column using a user-defined function that I discovered while visiting an
Can we alter the computed column in SQL Server
Can we alter a computed column in SQL Server? The answer is- NO. A calculated column is basically a virtual column that isn’t physically stored
Big Data & SQL 