Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag data validation Rss

   Items 1 to 3 of 3   
 

Where in the Application Should Data Validation be Done?

Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.   Read more...
By Additional Articles 2014/11/19 | Source: SimpleTalk | Category: data validation
Rating: (not yet rated)  Rate this |   Briefcase | 10,008 reads

Function to find non-printable characters

The function is used to find non-printable ASCII characters in an input string.  Read more...
Rating: |  Discuss |   Briefcase | 1,411 reads

SQL Server CLR function to improve performance of validating email addresses

I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?  Read more...
By Additional Articles 2009/02/03 | Source: MSSQLTips.com | Category: sqlclr
Rating:  Rate this |   Briefcase | 3,242 reads
   Items 1 to 3 of 3   
 
Tags
data cleansing (1)    
extract, transform, load (etl) (1)    
sqlclr (1)