Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: trigger

    Thanks allot for helping but am getting error message. I have Put in the tables in:

    CREATE TABLE Car

    (

    [VehNo] ...

  • RE: would need some help

    Thanks Allot Old Hand,

    I am just following a book for the coding. Would follow the what you have suggested. And thanks for the steps. It does helps me on my...

  • RE: would need some help

    hi,

    Thanks Allot. I would follow your steps and wish i could make it out.

    for to your question,I declare a CONSTRAINT ServiceCodeValues in my serviceTAble. and not sure if i...

  • RE: would need some help

    Hi Sean Lange,

    This is my coding so far but allot of errors:

    ALTER TABLE ServiceTable

    ALTER COLUMN serviceCode char(4) NOT NULL,

    ALTER TABLE CaseTable

    DROP CONSTRAINT serviceCodeValues,

    ALTER TABLE CaseTable

    ALTER serviceCode DROP DEFAULT,

  • RE: would need some help

    Hi Sean Lange,

    I am a new to SQL. And i try doing looking at a book but gives me error and lots of it. i am not sure how to...

Viewing 5 posts - 1 through 6 (of 6 total)