Sql validating populated columns

Check out all our database development sessions at OOW19 Thanks for the question, Nikhil.

Asked: April 22, 2016 - am UTC Answered by: Connor Mc Donald - Last updated: May 06, 2016 - am UTC Category: Developer - Version: Viewed 10K times!

Then you could check the month/day mappings individually..now you've got leap years to look out.

If your form template already has a secondary data connection that you can use, you can skip this section and go to Step 2: Configure the control.

Just yesterday I had a colleague ask if I could help document all the columns in each table in one of our databases to share with a vendor working on an interface between that system and one the vendor developed for a different aspect of our business.

As my procedure requires the date format as 'MM/DD/YYYY' and if any other format is passed through input file it will update the error description column as invalid date format . Note - I don't want any function created for the same Thanks in advance..!!!

"Note - I don't want any function created for the same" - why ? Well, you could use a regular expression to get pretty close:^(?

Leave a Reply