Allvendors | Database Star: Home

SQL Commands: A List with SQL Syntax

Jul 15, 2020 · 15 min read ·
Share on:

Let's take a look at the SQL commands and the SQL syntax for them.

Read More
SQL Get Current Date

Jul 15, 2020 · 7 min read ·
Share on:

Learn how to get the current date in SQL.

Read More
SQL Create Database: A How-To Guide

Jul 14, 2020 · 4 min read ·
Share on:

Learn how to create a database in SQL.

Read More
SQL Auto Increment: How to Use It in Different Databases

Jul 9, 2020 · 9 min read ·
Share on:

Learn how to set this up in SQL Server, MySQL, PostgreSQL, and Oracle in this article.

Read More
A Beginner's Guide to an SQL Cursor (In Many Databases)

Jul 6, 2020 · 21 min read ·
Share on:

Learn what SQL cursors are and how to use them.

Read More
SQL vs MySQL vs SQL Server: What's the Difference?

Jun 27, 2020 · 4 min read ·
Share on:

Learn the difference between SQL and MySQL.

Read More
SQL CAST Function Explained with Examples

Apr 30, 2020 · 7 min read · sql-functions ·
Share on:

The SQL CAST function is quite powerful, but it can be hard to use. Learn how to use it and what it can do in this article.

Read More
The Ultimate Guide to Database Version Control, CI/CD, and Deployment

Feb 1, 2020 · 40 min read · sql ·
Share on:

In this guide, I'll explain that there's a better way to handle changes to your database and how to get it under version control, tested, and deployed along with application code.

Read More
SQL DATEDIFF Function Guide and Examples

Jan 14, 2020 · 4 min read · sql-server ·
Share on:

The SQL Server DATEDIFF function lets you find the difference between two dates in a range of different units. Learn how to use it and see a range of examples in this guide.

Read More
SQL Comments: A How-To Guide

Jan 9, 2020 · 7 min read · mysql oracle postgresql sql-server ·
Share on:

Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article.

Read More
- 2
- 3
- 4
- 5
- 6