2.1.1.20 E171, SQLSTATE support

  • Article

V0020:

The specification states the following:

 Subclause 24.1, "SQLSTATE":
  
 The character string value returned in an SQLSTATE parameter comprises a 2-character class value followed by a 3-character subclass value, each with an implementation-defined character set that has a one-octet character encoding form and is restricted to <digit>s and <simple Latin upper case letter>s. Table 33, "SQLSTATE class and subclass values", specifies the class value for each condition and the subclass value or values for each class value.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. However, Transact-SQL does support five-character parameters that are similar to SQLSTATE for indicating the successful completion of a statement or the raising of an exception.