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:
Post a Comment