LCI Learning

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Parthasarathi Loganathan (Advocate)     31 October 2010

Wedding Query

 

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

 

HUSBANDS QUERY

 

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 =Full

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 wife writes the below query:

 

DROP HUSBAND;

Commit;



Learning

 0 Replies


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register