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
На этой странице сайта вы можете посмотреть видео онлайн SQL Server Data Validation Examples: Numeric and Date Fields длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь DataResearchLabs 21 Август 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 2,628 раз и оно понравилось 23 зрителям. Приятного просмотра!
