A correlated subquery is one that makes use of values from the outer query. Because of this dependency, a correlated subquery cannot be executed as
Category: SQL Server
String and Arithmetic Expressions in SQL Server
The intention of this post is to explain the regularly used string and arithmetic expressions. CHARINDEX: This function searches for a substring in a string,
Transaction Control Language – SQL Server
Transaction Control Language (TCL) commands are used to manage transactions in the database generated by DML statements. The statements are allowed to be grouped together
INSERT IGNORE Statements in SQL Server
We have INSERT statements in MySQL that are based on several circumstances. To prevent duplicates, we can recommend that the insert statement fail if the
Sub-Queries in SQL Server
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
CREATE or ALTER STORED PROCEDURE – SQL Server
There are times when we believe that a procedure does not exist in the database and attempt to create it; however, if the procedure already
Big Data & SQL 