Post reply

Update Script

  • July 15, 2013 at 12:14 am

    #277419

    Hi Team,

    I've a Table with 500+ records, in that one column name is 'Sec_Name' having some values as null (approx 150 records),

    with the same table name i've another table in another database, in that i want to update the null value records,

    i want a update script for all 150 records.

    how to get the udpate script for all 150 records.

    --

    am trying to generate scripts from Tasks > generate scripts but there am gettting for all the records.

    i want condition.

    Please help....

  • July 15, 2013 at 12:47 am

    #1632308

    Add a filter to your query to select only the NULL values. Remember that because of the NULL values an equal sign doesn't work. You have to use the IS keyword.

    -- below will work with NULL values

    WHERE {columnname} IS NULL

    -- while the line below doesn't...

    WHERE {columnname} = NULL

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 2 (of 2 total)

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