SQL Server Data Validation Examples: Numeric and Date Fields

Veröffentlicht am: 21 August 2021
auf dem Kanal: DataResearchLabs

2,628

This video walks you through 11 standard data validation test case examples. The numeric validation tests check for nulls, negative numbers, inside a specific range, in a list, not in a list, and comparing multiple numeric fields or doing calculations. The date validation tests check for nulls, dates inside a range, make sure there is or is not a time part, and comparing multipe date fields. There is also a bonus tip showing how to handle date overlaps when joining tables...ensuring that table#1 start/end dates overlaps table#2 start/end dates when you pull them together in a join.

You can refactor and re-use the samples in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests.

------ Chapter Timestamps (click to jump forward): ----------------------------
0:00 - Intro
0:07 - Introducing Rule Set #4 - Numeric Values
4:11 - Introducing Rule Set #5 - Date Values
7:47 - Bonus Tip: Joining Tables with 2 Pairs of Start-End Date Overlaps
11:00 - The End

Downloads:
Rule Set #4: https://github.com/DataResearchLabs/s...
Rule Set #5: https://github.com/DataResearchLabs/s...
Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/s...

Watch related playlist videos:
   • SQL Server Scripts for Data Analysts

Connect with me on social media:
LinkedIn:   / mpiercead576
YouTube:    / @dataresearchlabs
GitHub: https://github.com/DataResearchLabs

Subscribe to my YouTube Channel:
   / @dataresearchlabs

#MSSQL #automation #datavalidation

Auf dieser Seite können Sie das Online-Video SQL Server Data Validation Examples: Numeric and Date Fields mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer DataResearchLabs 21 August 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 2,628 Mal angesehen und es wurde von 23 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!