SQL style wedding database queries

 

 

 

Wedding Queries........ ........ (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 =Null
 
 

SELECT Gold ,Cash,Car,BankBalance

FROM FatherInLaw    

UPDATE MyBankAccout

SETMyBal = MyBal + FatherInLawBal

UPDATEMyLocker

SET MyLockerContents = MyLockerContents + FatherInLawGold

INSERT INTOMyCarShed VALUES('BMW')
END
GO  

Then the wife writes the below query:  

DROP HUSBAND;
Commit; J

 

 

Posted via email from theanand's posterous