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;