Wednesday, October 7, 2009

SQL style invitation

Marriage invitation by some Database Geeks, not invented by me, the recipient.
*
**
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