Advanced SQL Query ...................

Wedding Query........ ........ (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 ,MBA) AND Having Brothers= Null AND Sisters =Yes J



SELECT Gold ,Cash,Car,BankBalance

FROM FatherInLaw

UPDATE MyBankAccout

SETMyBal = MyBal + FatherInLawBal

UPDATEMyLocker 

SET MyLockerContents = MyLockerContents + FatherInLawGold

INSERT INTO MyCarShed VALUES('BMW')
END
GO 
wife writes the below query:
DROP HUSBAND;
Commit; J

  


--
With Warm Regards,
Jerome Jackson Rodrigues
http://rodriguesjax.blogspot.com
https://twitter.com/rodriguesjax