MSSQL Data Validation Examples: Regular Expressions with LIKE Operator скачать в хорошем качестве

MSSQL Data Validation Examples: Regular Expressions with LIKE Operator

This video walks you through 14 regular expression data validation test case examples. There are validation tests for phone numbers, social security numers, zip5 and/or zip9, text only, numeric only, no leading or trailing whitespace, only lowercase, only uppercase, titlecase, email addresses, and urls. Included also are two tips on web searches to support use of regular expressions: (1) search on "regular expression X" where X is the data element to validate (eg: phone number), and (2) search on "regular expression builder" (or tester) for excellent free tools that let you dial in a regular expression against text data all on a simple web page. 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 #7 - Regular Expressions 10:46 - How to Download SQL Scripts in this Video 12:19 - The End Downloads: Rule Set #7: 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   Background Music (via YouTube "always free" Audio): "Rewind" by Ofshane:    / @ofshane   #MSSQL #automation #datavalidation