You need to manually raise an error.
The error message that will be returned will display a message that contains
parameters 1, 2, 3
sp_addmessage @msgnum = 6000,
@severity = 16,
@msgtext = N’Your message (%d), (%d), (%d)’;
GO
You have to raise message to get correct message.. ‘Your message (1), (2), (3).’
Which statement will you use?
A.
RAISE_ERROR(60000, 16, 1, 1, 2, 3)
Explanation:
CORRECT ANSWER:RAISERROR (6000, — Message id.
16, — Severity,
1, — State,
, 1, 2, 3)