proc1.sql

python web programming 部分

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