SQL Server ROW_NUMBER SQL Function
In this guide, you’ll learn all about the ROW_NUMBER function in SQL Server.
Dynamic SQL: A Guide for SQL Server, Oracle, MySQL, and PostgreSQL
Dynamic SQL is a handy feature of a database that lets you construct SQL statements in a different way.
MySQL Drop All Tables: How-To With Examples
There may come a time when you need to drop all tables in a MySQL database.
In this article, you’ll learn how to do that easily, both using an SQL command an inside an IDE such as MySQL Workbench.
Let’s see how we can do that.
How to Reset IDENTITY Column Values in SQL Server
Do you want to reset an identity column in your table in SQL Server so the numbers are in order?
And you want to do it without recreating the table?
In this article, I’ll show you how you can do this, and a few things to be aware of.
Let’s take a look.
SQL Rename Table: How To with Examples
Once you create a table in SQL, you may want to rename it. This might happen if you are creating a new table to replace it, or have come up with a better name for it.
In this article, you’ll learn the SQL commands to rename a table in Oracle, SQL Server, MySQL, and PostgreSQL, along with examples of each.
Let’s get into the article.
MySQL Create User and Grant Permissions: How To
If you work with MySQL, there will be a point when you’ll need to create a new user.
This could be for another part of the system or another developer on your team. Or perhaps you want to use a user other than the default “root” account on MySQL.
MySQL Date Data Types and Date Functions
Working with dates is something you’ll do a lot in MySQL.
It helps to understand the different date data types and many of the functions that can be used with them.
In this guide, we’ll look at the MySQL date data types, the date functions, and see some examples of them.
SQL Add Column: A How-To Guide with Examples
Do you need to use SQL to add a column to your table?
It’s easy to do once you know the command and the syntax.
Let’s take a look at how to do it in several different databases and see some examples.
51 SQL Editors and IDEs Compared (2020): The Ultimate List
SQL Window Functions: The Ultimate Guide
What is an SQL window function? Why should you know about it? And what can it help you with?
You may have heard of SQL window functions before, or they may be completely new to you.
Learn all about them in this guide.
