SQL Server Data Validation Examples: Numeric and Date Fields
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
On this page of the site you can watch the video online SQL Server Data Validation Examples: Numeric and Date Fields with a duration of hours minute second in good quality, which was uploaded by the user DataResearchLabs 21 August 2021, share the link with friends and acquaintances, this video has already been watched 2,628 times on youtube and it was liked by 23 viewers. Enjoy your viewing!
