WeddingQuery……. …….. (SQL Style)


WeddingQuery....... ........ (SQL Style) :)

CREATE PROCEDURE MyMarriage
BrideGroom 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,BankBalanceFROM FatherInLaw ;
UPDATEMyBankAccout SETMyBal = MyBal + FatherInLawBal;
UPDATEMyLockerSET MyLockerContents = MyLockerContents + FatherInLawGold;
INSERT INTOMyCarShed VALUES(‘BMW’);
END
GO

Then the wife writes the below query:

DROP HUSBAND;
Commit;

Enhanced with Snapshots

Advertisements

One comment on “WeddingQuery……. …….. (SQL Style)

  1. Hi All,

    I invite you to view my new web site (http://www.techgyaan.org) for latest updates on IT & Technology.

    I do not host technical post here anymore (https://rules.wordpress.com), I’ve moved all my post to my own website – (http://www.techgyaan.org)
    We are pleased to announce the launch of our new-look web site. We hope that you find it easy and enjoyable to use.

    For your comment & feedback please do write a mail info@techgyaan.org

    This blog will continue with my personal updates

    So, thank you folks for a great time, and see you all there!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s