
Showing posts with label fun. Show all posts
Showing posts with label fun. Show all posts
Wednesday, December 12, 2007
Thursday, November 22, 2007
Wedding Query............. (SQL Style)
Wedding Query............. (SQL Style)
CREATE PROCEDURE MyMarriageBridegroom Male (25) ,Bride Female(20) ASBEGINSELECT Bride FROM India_ BridesWHERE Father-In-Law = 'Millionaire' AND Count(Car) > 20 AND House Status ='ThreeStoreyed'AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND Having Brothers= Null AND Sisters =Null
SELECT Gold ,Cash,Car,BankBalanceFROM Father-In-Law
UPDATE MyBankAccout SETMyBal = MyBal + FatherInLawBal
UPDATE MyLockerSET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTOMyCarShed VALUES('BMW')
END
GO
Then the wife writes the below query:
.
..
.
.
.
..
.
.
.
.
.
..
..
.
.
..
.
.
.
.
.
.
.
.
.
.
.
.
DROP HUSBAND;
Commit;
CREATE PROCEDURE MyMarriageBridegroom Male (25) ,Bride Female(20) ASBEGINSELECT Bride FROM India_ BridesWHERE Father-In-Law = 'Millionaire' AND Count(Car) > 20 AND House Status ='ThreeStoreyed'AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND Having Brothers= Null AND Sisters =Null
SELECT Gold ,Cash,Car,BankBalanceFROM Father-In-Law
UPDATE MyBankAccout SETMyBal = MyBal + FatherInLawBal
UPDATE MyLockerSET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTOMyCarShed VALUES('BMW')
END
GO
Then the wife writes the below query:
.
..
.
.
.
..
.
.
.
.
.
..
..
.
.
..
.
.
.
.
.
.
.
.
.
.
.
.
DROP HUSBAND;
Commit;
Subscribe to:
Posts (Atom)
