In SQL Server, you may create a check constraint in a table to specify the data values that are permitted in one or more columns.
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.
SQL Server – Foreign Key References – With Cascade
A foreign key is a mechanism for ensuring referential integrity in the SQL Server database. A foreign key indicates that values from one table must
Merge in SQL Server
The MERGE command synchronizes two tables by adding, removing, and modifying target table rows based on the source table’s join condition. In other words, when
MySQL – Dump All Database 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
MySQL ERROR 1227 (42000) at line 18: Access denied
While dumping the database using mysqldump, sometimes we encounter the following warning message. Warning: A partial dump from a server that has GTIDs will by
MySQL Error:1175 UPDATE in MySQL Workbench
When trying to update a row in a table using MySQL Workbench, you could occasionally encounter the following error. Error Code: 1175. You are using
Big Data & SQL 