MSCEWI4047

RAISERROR Error Message may differ because of the SQL Server string format.

Severity
Medium
Description
This EWI is added to notify that the RAISERROR Error Message may differ because of the SQL Server string format.
Code Example
Input Code:
CREATE PROCEDURE RAISERROR_PROCEDURE 
AS
BEGIN
RAISERROR ('This is a sample error message with the first parameter %d and the second parameter %*.*s',
           10, 
           1,
           123,
	   7,
	   7,
	   'param2');
END
Output Code:
CREATE OR REPLACE PROCEDURE PUBLIC.RAISERROR_PROCEDURE ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
           BEGIN
                      /*** MSC-WARNING - MSCEWI4047 - RAISERROR ERROR MESSAGE MAY DIFFER BECAUSE OF THE SQL SERVER STRING FORMAT ***/
                      SELECT
                                 RAISERROR_UDF('This is a sample error message with the first parameter %d and the second parameter %*.*s',
                                 10,
                                 1, array_construct(
                                 123,
                                 7,
                                 7,
                                 'param2'));
           END;
$$;
Recommendations
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI4046

MSCEWI4048

Last modified 6mo ago