Click or drag to resize

SA0202 : The text and image functions TEXTPTR and TEXTVALID are deprecated

The topic describes the SA0202 analysis rule.

Message

The text and image functions TEXTPTR and TEXTVALID are deprecated

Description

The rule checks for usages of the deprecated functions TEXTPTR and TEXTVALID.

This feature is in maintenance mode and may be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Alternative functionality is not available for the functions.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

New Rules, Deprecated Features

Additional Information
Example Test Script
SQL
1select  pub_id,
2        TEXTPTR(pr_info),
3        'Valid (if 1) Text data' = TEXTVALID('pub_info.logo',TEXTPTR(logo))
4from pub_info
5order by pub_id;

Analysis Results

 MessageLineColumn
1SA0202 : The text and image functions TEXTPTR and TEXTVALID are deprecated.28
2SA0202 : The text and image functions TEXTPTR and TEXTVALID are deprecated.335
3SA0202 : The text and image functions TEXTPTR and TEXTVALID are deprecated.361
See Also

Other Resources