CREATE PROCEDURE MyMarriage BrideGroom Male (29), Bride Female(24) AS BEGIN SELECT Bride FROM All_ Brides WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 10 AND HouseStatus = 'TwoStorey_Fully_Furnished' AND BrideEduStatus IN (Bachelor Degree, Masters Degree) AND Having Brothers = Null AND Sisters = Null SELECT Gold, Cash, Car, BankBalance FROM FatherInLaw UPDATE MyBankAccout SET MyBal = MyBal + FatherInLawBal UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold INSERT INTO MyCarShed VALUES ('BMW') END GO Then the Bride writes the below query: DROP HUSBAND; Commit;
Ganjadi · Dec 4, 2009 2:54 PM · 11,072 views
lol
stolen_thoughts · Dec 4, 2009 3:28 PM
Thats funny.....But the Bride query is wrong, it will give error - so don't worry if you have implicit transactions set to true already. You cannot issue commit if u don't have a begin tran. Or else write DDL trigger, so that anytime Bride issue a Drop statement, trigger will fire. Nice one....Do u have more?........
STUPIDA · Dec 4, 2009 4:25 PM
SOmething funny happen here. I copy and pasted this query in my compnay and send to my co-worker. But there is something that when u click the body part in the email, it goes to some porn sites.......... Guys do not do this plese
STUPIDA · Dec 4, 2009 4:35 PM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion