PlanetEnjoy.com

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

CREATE PROCEDURE MyMarriage
@
BrideGroom
Char(NotBad),
@
Bride
Char(Good)

AS


BEGIN

SELECT
Bride FROM

india_ Brides


WHERE
FatherInLaw = ‘Millionaire’

AND
CarCount > 2
AND
HouseStatus =’TwoStoreyed’
AND

BrideEduStatus=’PG
orAbove’ AND

HavingBrothers=’NO’
AND

HavingSisters =’No’
AND
AllowRelocate =’YES’

SELECT
Gold ,Cash,Car,BankBalan ce
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;