Find the errors if possible - SQL query
CREATE PROCEDURE MyMarriage
BrideGroom Male (25) ,
Bride Female(20) AS
BEGIN
SELECT Bride FROM india_ Brides
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) 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...........:sshhh:
BrideGroom Male (25) ,
Bride Female(20) AS
BEGIN
SELECT Bride FROM india_ Brides
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 AND HouseStatus ='ThreeStoreyed'
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) 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...........:sshhh:
Replies
-
csiscoolha ha.. what a pity 😉 -
Chaitali Sumitahello...
the answer to your sql query goes like this in 'C' programming language....
#include
#include
void main()
{
int choice;
printf("DO you require a bride or your would be father-in-law's money??\n
please ENTER your choice");
printf("PRESS 1 for bride");
printf('PRESS 2 for money");
printf("PRESS 3 if you have changed your decision");
scanf("%d",&choice);
switch(choice)
{
case1:
printf("hurrray!!!😁 you have got the bride...but oops...no money......\n congratulations for your married life\n do send us your marriage card!!😁");
break;
case2:
printf("hurray!!!😁you have got a lumsome amount of money!!!....\n now enjoy with your father-in-law......\n start throwing parties 🎉and dont forget to invite us!!;-)");
break;
case3:
printf(" NO MONEY,NO BRIDE....
NOW KEEP CLAPPING IN YOUR LIFE!!!:clap:.... ha ha ha");
break;
default:
printf("WRONG CHOICE!!!NOT according to your demand!!\n you are bound to press 1 if you want the error....\n you will definitely get the answer(error in your life).....😛");
}
getch();
}
You are reading an archived discussion.
Related Posts
i am doing my project on networking. i need to implement icmp protocol. please anybody help me out and tell me how to implement this protocol. please reply soon.
if i want to provide e-certificates(i.e rating )to a particular group among the users of my website then which approach should i use?
Hi,
I want to make a java application for my project. I've to make a GUI and connect a phone to my PC. If a certain button in the GUI...
frndz tell any good project title
Wake On LAN Ex 2.07
Wake On LAN Ex is an application designed to be used with computers that contain network cards which are set to turn on when a...