What is data validation in SQL and why is it important? Data validation is a method for checking the accuracy and quality of data. Information in databases is constantly being updated, deleted, queried, or moved by multiple people or processes, so ensuring that data is valid at all times is essential. In this article, we’re …
SQL Spreads Blog
-
Simple Data Validation in SQL
Andy McDonald - Oct 24, 2021 -
How to create Pivot Tables in SQL Server
Andy McDonald - Oct 10, 2021In this article, we’re going to show you how to create pivot tables in SQL Server. This is the third article aimed at teaching Excel users some basic SQL server queries, and how to mimic some of the main functions used in Excel. In a previous article we looked at the equivalent of Excel’s VLOOKUP …
-
What is the equivalent to VLOOKUP in SQL?
Andy McDonald - Sep 11, 2021In this article, we’re going to show you how to perform the equivalent of Excel’s VLOOKUP in SQL. This is the second of our articles aimed at teaching Excel users the basics of SQL. In our previous article “Introduction to SQL for Excel Users”, we introduced the JOIN statement, and here we’re going to expand …
-
Introduction to SQL for Excel Users
Andy McDonald - Aug 27, 2021This is the first of several articles on SQL for Excel users. The aim is to show you why it’s so useful for Excel users to be familiar with SQL and to introduce some basic concepts and queries. Why is it important to learn SQL? In a previous article, SQL and Excel: Why you need …
Contact
Company
Obnex Technologies AB
Chalmers Innovation, Stena Center 1A
S-412 92 Göteborg, SWEDEN
Registration number: 556671-8564
VAT: SE556671856401
Chalmers Innovation, Stena Center 1A
S-412 92 Göteborg, SWEDEN
Registration number: 556671-8564
VAT: SE556671856401