Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Updating Multiple row subquery ..!! Help ..

    Hi Hope it helps..

    CREATE TABLE TBL_NAMES(

    NAMES VARCHAR(50),

    AGE INT,

    BIRTH_DATE DATETIME

    )

    CREATE TABLE EMPLOYEE(

    EMP_NAME VARCHAR(50),

    EMP_AGE INT

    )

    INSERT INTO TBL_NAMES VALUES('Senthil',21,GETDATE());

    INSERT INTO TBL_NAMES VALUES('Kumar',23,GETDATE());

    INSERT INTO TBL_NAMES VALUES('Mathan',29,GETDATE());

    INSERT INTO TBL_NAMES VALUES('John',25,GETDATE());

    INSERT INTO EMPLOYEE VALUES('Senthil Nathan',21)

    INSERT...

Viewing post 1 (of 1 total)