Find the errors if possible - SQL query

Mahesh Dahale

Mahesh Dahale

@mahesh-E2tZ3t • Oct 22, 2024
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:
Like 0 Replies 2

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • csiscool

    csiscool

    @csiscool-qA5mGA • Jan 23, 2010

    ha ha.. what a pity 😉
    0
  • Chaitali Sumita

    Chaitali Sumita

    @chaitali-sumita-Bn5O8f • Feb 24, 2010

    hello...
    the answer to your sql query goes like this in 'C' programming language....


    #include<stdio.h>
    #include<conio.h>
    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();
    }
    0