Bride's Query: Create Procedure

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 4

 

Bride's Query

CREATE PROCEDURE
MyMarriage (
BrideGroom Male (25) ,
Bride Female(20) )
AS
BEGIN

SELECT BrideGroom FROM


india_ BrideGroom
WHERE FatherInLaw =
'Millionaire'
AND Count(Car) > 20 AND
HouseStatus ='ThreeStoreyed'
AND BrideGroomEduStatus IN
(B.TECH ,BE ,Degree
,MCA ,MiBA) AND Having
Brothers= Null
AND Sisters =Null
And Height = 6 ft
And Color = white

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

Bride Groom's query:

DROP MyMarriage;
Create Girlfrnd;
Commit;
 

Advance Diwali Wishes


 
 
 
 
 

You might also like