Showing posts with label fun. Show all posts
Showing posts with label fun. Show all posts

Wednesday, December 12, 2007

What is wrong in my answer

Are you dare to write the exam like this

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;