|
|
WeddingQuery. ...... ....... (SQL Style)
Posted On: 23/11/2007 03:54:27
|
CREATE PROCEDURE MyMarriage Bride Male (25) , Bride Female(20) AS BEGIN SELECT Bride FROM india_ Brides WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed' AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) AND Having Brothers= Null AND Sisters =Null
SELECT Gold ,Cash,Car,BankBalan ce FROM FatherInLaw UPDATE MyBankAccout SET MyBal = MyBal + FatherInLawBal UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold INSERT INTO MyCarShed VALUES ('BMW') END GO
Then the wife writes the below query:
DROP HUSBAND; Commit;
|