Forum Replies Created

Viewing 6 posts - 16 through 22 (of 22 total)

  • RE: I want to create primary key after inserting foreign key.

    Hi Gila,

    Thanks for the update. I will give you sufficient reasoning below the logic, the logic is that every student need not register parent user id, but every parent userid...

    I was very good at sql but variety spoiled me ! :w00t:
  • RE: I want to create primary key after inserting foreign key.

    Hi Jeff,

    Please let me know what is DRI. I found a workaround though which can be helpful, can you disable the constraint of foreign key related to that master table...

    I was very good at sql but variety spoiled me ! :w00t:
  • RE: not updating inserted row in an insert trigger

    Hello Professionals,

    I would like to take this opportunity to thank every one of you. My project is resolved on my own trigger which I have posted. I just changed vperc...

    I was very good at sql but variety spoiled me ! :w00t:
  • RE: not updating inserted row in an insert trigger

    Hello Corbett, Darkfour, and Stewart,

    Thank you for your big response. I am overwhelmed. But there is one thing which I have noticed in the new script given by Stewart is...

    I was very good at sql but variety spoiled me ! :w00t:
  • RE: not updating inserted row in an insert trigger

    Hi Stewart,

    when I shuffled @vperc int, to up 3 locations it is still giving error at line 30 for another variable and the error code I get is as follows:-

    Msg...

    I was very good at sql but variety spoiled me ! :w00t:
  • RE: not updating inserted row in an insert trigger

    Hi Stewart ,

    Thank you a lot. That was really great efforts from your end, I have copied and tried to compile but it is giving error at line 30 which...

    I was very good at sql but variety spoiled me ! :w00t:

Viewing 6 posts - 16 through 22 (of 22 total)