Wedding Query

[xcorect]

CREATE PROCEDURE MyMarriage
BrideGroom Male (25) ,
Bride Female(20) AS
BEGIN
SELECT Bride FROM lanka_ Brides
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND Having Brothers= Null AND Sisters =Null

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;

Find the errors if possible.... .......​

 

[elakiri0777]

he he...

 

[kasunsankalpana]

Lolz

 

[Clerk_Kent]

Ha ha haa..ela ban.....

 

[amilazzz]

He he.......LoLZ !

 

[northtech]

nice !

 

[asanka10]

hik hikzzzz

 

[nj542]

CREATE PROCEDURE MyMarriage
BrideGroom Male (25) ,
Bride Female(20) AS
BEGIN
SELECT Bride FROM lanka_ Brides
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND Having Brothers= Null AND Sisters =Null

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;

Find the errors if possible.... .......​

DROP
HUSBAND;
Commit;

or

DIVORCE;
Commit;

 

[yasaswan]

thawa godak add karanna puluwan ne...

 

[shelan]

CREATE PROCEDURE MyMarriage
BrideGroom Male (25) ,
Bride Female(20) AS
BEGIN
SELECT Bride FROM lanka_ Brides
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MBA) AND Having Brothers= Null AND Sisters =Null

SELECT Gold ,Cash,Car,BankBalance FROM FatherInLaw
UPDATE MyBankAccout SET MyBal = MyBal + FatherInLawBal
UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTO MyCarShed VALUES ('BMW')

if (success)
" +r" //read only

go
end



Then the wife writes the below query:

DROP
HUSBAND;
commit;

return-->"cant append the file- read only"








​

I think nw thr is no prob!!!!

 

[shelan]

Nw the problem is no more!!!