*
**
CREATE PROCEDURE** MyMarriage
@**BrideGroom** Char(NotBad),
@**Bride** Char(Good)**
AS* *
SELECT** Bride **FROM**
Brides **
WHERE**
FatherInLaw = 'Millionaire' **AND**
CarCount > 2 **AND**
HouseStatus ='TwoStoreyed' **AND**
BrideEduStatus='PGorAbove' * *
HavingBrothers='NO' **AND**
HavingSisters ='No' **AND**
AllowRelocate ='YES' **AND**
* *
**SELECT** Gold, Cash, Car, BankBalance **FROM** FatherInLaw
**UPDATE** MyBankAccout **SET** MyBal = MyBal + FatherinLawBal* *
**UPDATE** MyLocker **SET** MyLockerContents = MyLockerContents +
FatherinLawGold
**
INSERT INTO** MyCarShed **VALUES** ('Ford')*
No comments:
Post a Comment