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
Category: RDBMS
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
ALTER TABLE Statements in SQL Server
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. It is also used to add and remove various
ALTER DATABASE in SQL Server
This article will go over various ALTER DATABASE statements in SQL Server. This aids in changing the database name, properties, files, recovery methods, file locations,
Big Data & SQL 