CREATE PROCEDURE MyMarriage
@BrideGroom Char(NotBad),
@Bride Char(Good)
AS
SELECT Bride FROM
BridesList
WHERE
FatherInLaw = 'Millionaire'
AND CarCount > 2
AND HouseStatus ='TwoStoreyed'
AND BrideEduStatus='PG_or_Above'
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 ('Ford')
Hi Sandesh,
ReplyDeleteI am very much impressed with your blog.Cool design,nice features and you have great SQL knowledge.what more its rocking dude.Keep it up.I'll tell all my friends to visit your blog.
Regards
Harsha J
:):) ..a small correction.. change the spelling "Juat" .. i think you wrote just..
ReplyDelete:).. Bro dont feel bad in my comments.. i liked your blog... Its really good.. but i would love to see people calling it gr8 ..cheers..
Thanks Ash... For pointing my mistake.
ReplyDelete