web 2.0

Friday, January 28, 2011

Query


Hi guys .... This is in the form of Database programming in IT, but hope everyone can enjoy...



Cheers!!!!!! !

CREATE PROCEDURE MyMarriage

@ BrideGroom Char ( NotBad) ,
@ Bride Char ( Good )

AS
BEGIN

SELECT Bride FROM COLOMBO Brides
WHERE
FatherInLaw = 'Millionaire' AND
CarCount > 2 AND
HouseStatus ='TwoStoreyed' AND
BrideEduStatus = 'PG orAbove' AND
YoungerSisters > 0 AND
HavingBrothers = 'NO' AND
HavingElderSisters ='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:

FORMAT HUSBAND

2 ප්‍රතිචාර:

Hishan de Silva said...

Wife "FORMAT HUSBAND" කියල කියනවනම් ඒක කියලවත් කොර ගන්න බැරි වැඩක් නෙව...

Dilanka Madhawa said...

ඒකනම් ඇත්ත

Post a Comment

ආපු එකේ කොමෙන්ට් එකක් දාලම යන්නකෝ...

පස්සෙන් එන්න