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

Posted on Updated on

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;

Source: yrandhir@hotmail.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s