Looks for a pattern within the string and will fail if specified patter were found in the string. 

Arguments

  • v_Pattern - An expression that contains the pattern string to be found, NVARCHAR(MAX)
  • v_String - String that is searched for the specified pattern. NVARCHAR(MAX)
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)

 

Examples

SQL Server

      EXEC DBTD_ASSERT_STRING_NOT_CONTAIN  '%aaa%', '1111aaabbbbcccc', 'We have issues';

 

See Also