---
title: "Automatic Data Validation"
slug: "automatic-data-validation"
description: "Every entry is validated against the SQL Server column data type as it is typed, so invalid values are rejected before they reach the database."
updated: 2026-11-05T16:27:53Z
published: 2026-11-05T16:27:53Z
canonical: "sqlspreads.com/automatic-data-validation"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Automatic Data Validation

## Data Validation in SQL Spreads

SQL Spreads will **automatically validate all data entries** against the specified data types in your database. This mechanism ensures that the data input quality is high, and is an additional **safeguard measure** for your database integrity.

This mechanism is triggered as soon as an end user enters a value into a column. In this example, a Job Title (Nvarchar data type) value will be incorrectly entered into a Birth Date (Date data type) column.

![Incorrect Data Type Entry](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Incorrect%20Data%20Type%20Entry.PNG)

After entering the string value, an error message immediately pops up stating that it is an invalid value. The error message will guide the user to **enter the correct data type**, in this example, valid dates equal to or later than 1900-01-01. ![Automatic data validation error message](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Automatic%20data%20validation%20error%20message.PNG)

Thus, the incorrect data types cannot be saved back to the SQL database.

Customized data validation

The preferred way to add custom validation is to [add a constraint](https://learn.microsoft.com/en-us/sql/relational-databases/tables/unique-constraints-and-check-constraints?view=sql-server-) to the SQL Server column in SQL Server Management Studio.

If the above doesn't work, you can take a look at our [post processing feature](https://sqlspreads.com/docs/post-save-data-processing-scripts#example-1-adding-a-custom-data-validation) to add custom data validation.