Thursday, October 15, 2009

Wedding in sql





Wedding Query....... . (SQL Server Stored Procedure Style)


CREATE PROCEDURE MyMarriage
@BrideGroom Char(notBad) ,
@BrideChar(Good)


AS
BEGIN


SELECTBride FROMindia_Brides
WHERE
FatherInLaw = 'Millionaire' AND
CarCount > 2 AND
HouseStatus ='TwoStoreyed' AND
BrideEduStatus='PGorAbove' AND
HavingBrothers='NO' AND
HavingSisters ='No' AND
AllowRelocate ='YES'


SELECTGold ,Cash,Car,BankBalance FROMFatherInLaw


UPDATEMyBankAccout SETMyBal = MyBal + FatherinLawBal
UPDATE MyLockerSET MyLockerContents = MyLockerContents + FatherinLawGold


INSERT INTOMyCarShedVALUES('BMW')


END
GO


.


.


.


Then the wife writes the below query:


DROP HUSBAND


Commit;

No comments:

Post a Comment