proc1.sql

来自「python web programming 部分」· SQL 代码 · 共 24 行

CREATE PROCEDURE PubTakeOver
    @Acquirer  varchar(12),
    @Target varchar(12)
AS
DECLARE @acquirerNo int
DECLARE @targetNo int
SET @acquirerNo = (
    SELECT PubNo
        FROM Publisher WHERE PubName = @Acquirer)
SET @targetNo = (
    SELECT  PubNo
        FROM Publisher WHERE PubName = @Target)
IF @acquirerNo IS NULL OR @targetNo IS NULL
BEGIN
    RAISERROR('Takeover requires two valid publisher names', 15, 1)
END
ELSE
BEGIN
    UPDATE Book Set PubNo = @AcquirerNo
        WHERE PubNo = @TargetNo
    DELETE FROM Publisher
        WHERE PubNo = @TargetNo
END