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
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
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,
TRUNCATE TABLE in SQL
TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Big Data & SQL 