Что делает данный код? Я его взял из хранимых процедур SQL сервера.
| Код |
CREATE PROCEDURE dbo.WcWcValidSp (
@PWc WcType
, @PWcDescription DescriptionType OUTPUT
, @Infobar InfobarType OUTPUT
) AS
DECLARE
@Severity INT
SET @Severity = 0
DECLARE
@WcRowPointer RowPointerType
, @WcWc WcType
, @WcDescription DescriptionType
SET @WcRowPointer = NULL
SET @WcWc = NULL
SET @WcDescription = NULL
SELECT
@WcRowPointer = wc.RowPointer
, @PWcDescription = wc.description
FROM wc
WHERE wc.wc = @PWc
IF (@WcRowPointer IS NULL)
BEGIN
SET @Infobar = NULL
EXEC @Severity = MsgAppSp @Infobar OUTPUT, 'E=NoExist1'
, '@wc'
, '@wc.wc'
, @PWc
END
RETURN @Severity
GO
|
|