Thursday, November 24, 2011

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,BankBalance 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;

No comments:

Post a Comment