How to Rename a Table Name in SQL Server
One of the most critical database administrator’s duties is managing database objects. For...
SQL Basic Commands: How to Write Simple Queries with Examples
This article explains writing simple SQL queries from the most basic ones and gradually improving the script to solve some mathematical and...
Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function
Today’s code editors and word processors come with a search and replace feature. It is helpful when you need to change a word or a...
How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench
This article describes the step-by-step deployment process of the Azure Database for MySQL Server....
MySQL Insert Command vs T-SQL Query Syntax with Examples
Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp,...
SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios
The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
How to Round (UP/DOWN) in SQL Server – 5 Useful Tips
We’ve been taught to round numbers since we were kids. When you round off 1.15 to the nearest...
MySQL Create View, Replace View and Drop View Statements with Examples
An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical tables, views do not store data in a...
SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table
The right application of the DELETE statement for data removal is crucial, and it involves lots of issues. Still, there are standard...
CREATE TABLE MySQL vs T-SQL with Syntax Examples
Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to...
