CREATE PROCEDURE MyMarriage
BrideGroom Male (25) ,
Bride Female (20) AS BEGIN
SELECT Bride FROM India_Brides
WHERE Father-In-Law = 'Millionaire' AND Count(Car) > 20
AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH, BE, Degree, MCA, MBA)
AND Having Brothers= Null AND Sisters =Null;
SELECT Gold, Cash, Car, BankBalance FROM Father-In-Law
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 Aliance;
DROP Husband;
Commit;
Friday, November 2, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment