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...
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#,...
Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
SQL UNION Cheat Sheet with 10 Easy and Useful Tips
Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into...
Moving SQL Server Table to Different Filegroup
Introduction A table is a logical structure. When you create a table, you typically would not care which drives it sits on at the storage...
Do You Make These Mistakes When Using SQL CURSOR?
For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in the details! You can read all sorts of...
Virtual Columns and Functional Indexes
Much too often, we see poorly written complex SQL queries running against the database tables. Such...
How AI Will Change Software Development and Testing
Artificial intelligence is the fuel for what we know as the fifth industrial revolution. Its capacities to impact and disrupt numerous...
Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this statement is to add a new column to an existing...
Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms
This article describes the ways of using an INNER JOIN to combine results from two tables in the...
