ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)
This article focuses on the step-by-step processes of installing and configuring the ODBC driver...
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...
Microsoft SQL Server Express Edition Limitations and Versions
What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft...
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...
Connecting to SQL Azure from SQL Server Management Studio (SSMS)
Microsoft Azure is a cloud computing service for building, testing, deploying, and managing...
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 learn is MySQL CREATE TABLE statement....
Git Tips & Best Practices for Beginners
Without a version control system, it’s next to impossible to manage the source code. You can be a software developer of C, C#,...
Basics of SQL Server Management Studio (SSMS). Part 2
This article further explains the basics of SQL Server Management Studio (SSMS) – one of the most...
