Wednesday, 18 June 2008

Stored Procedure for Wedding

CREATE PROCEDURE MyMarriage

BrideGroom Male (25),
Bride Female(20)

AS
BEGIN
SELECT
Bride
FROM
india_ Brides
WHERE
FatherInLaw = ?Millionaire? AND

Count(Car) > 10
AND
HouseStatus = ?ThreeStoreyed?
AND
BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA)
AND
Having Brothers = Null
AND
Sisters = Null
SELECT Gold , Cash, Car, BankBalance
FROM
FatherInLaw

UPDATE
MyBankAccout
SET MyBal = MyBal + FatherInLawBal

UPDATE
MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold

INSERT INTO
MyCarShed
VALUES
(?BMW?)
END
GO

?Then the Bride writes the below query:?

DROP HUSBAND;
Commit;

No comments: