Post reply

updates on new tables

  • August 19, 2003 at 4:30 am

    #83048

    Is eem to be having a problem performing updates on new tables.....Im only using a very simple update statement:

    update genderpercentage set percentagefemale = 1

    The command works on existing tables but not on new ones..all permissions are the same and all data types seem to be correct...any ideas?

    Thanks guys

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • August 19, 2003 at 4:37 am

    #470379

    Just a guess.

    The user under which the new tables are being created is different then the one previously used.

    Pay Respect to People on your way up. For you will meet the same People on your way down.


    He who knows others is learned but the wise one is one who knows himself.

  • August 19, 2003 at 4:37 am

    #470378

    What's the error message you're getting?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 19, 2003 at 4:38 am

    #470380

    The user is the same...there is no error message, it just doesnt update.....

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • August 19, 2003 at 4:40 am

    #470381

    How many rows are in the table?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • August 19, 2003 at 4:45 am

    #470382

    Have u by any chance set value of IMPLICIT_TRANSACTIONS to on

    Pay Respect to People on your way up. For you will meet the same People on your way down.


    He who knows others is learned but the wise one is one who knows himself.

  • August 19, 2003 at 4:46 am

    #470383

    the table has 100 records in it

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    Edited by - achowe on 08/19/2003 04:50:22 AM


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • August 19, 2003 at 4:53 am

    #470385

    No, I think I have a solution though, the table was in fact empty..what a bloody fool!

    sorry guys..ill use an isert instead.

    just goes to show what staring at a screen for hours on end can do!......

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • August 19, 2003 at 4:55 am

    #470386

    Hi Andrew,

    quote:

    The command works on existing tables but not on new ones..all permissions are the same and all data types seem to be correct...any ideas?

    what do you mean by 'new ones'?

    Is there more than more table?

    Can you post the table structure?

    And maybe some sample data?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 19, 2003 at 4:57 am

    #470387

    ...and the value of @@rowcount after the update should be 100.

    is it?

    What is the value of @@trancount?

    From (another) QA window, can you:

    select count(*) from genderpercentage where percentagefemale = 1

    or:

    select count(*) from genderpercentage (nolock) where percentagefemale = 1

    Cheers,

    - Mark


    Cheers,
    - Mark

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply