CREATE PROCEDURE MyMarriage
@BrideGroom Char(notBad) ,
@BrideChar(Good)
AS
BEGIN
SELECTBride FROMindia_Brides
WHERE
FatherInLaw = 'Millionaire' AND
CarCount > 2 AND
HouseStatus ='TwoStoreyed' AND
BrideEduStatus='PGorAbove' AND
HavingBrothers='NO' AND
HavingSisters ='No' AND
AllowRelocate ='YES'
SELECTGold ,Cash,Car,BankBalance FROMFatherInLaw
UPDATEMyBankAccout SETMyBal = MyBal + FatherinLawBal
UPDATE MyLockerSET MyLockerContents = MyLockerContents + FatherinLawGold
INSERT INTOMyCarShedVALUES('BMW')
END
GO
.
.
.
Then the wife writes the below query:
DROP HUSBAND
Commit;
0 comments:
Post a Comment