Understanding DROP TABLE Statement in SQL Server
The SQL Server DROP TABLE statement serves to drop the table from the database. This article will...
Basics of SQL Server ALTER TABLE Statement
This article focuses on the ALTER TABLE statement in SQL Server and the following tasks on SQL Server tables: Add one or multiple columns...
SQL Reference Table: How to Create and Write Basic Queries
This article will focus on writing SQL queries against the database reference table with a fairly simple structure to understand and...
An Overview of the PRINT Statement in SQL Server
The SQL PRINT statement serves to display the user-defined message. For example, you are developing...
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...
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...
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 tenths, will it be 1.2 or 1.1? Using the...
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...
