Post reply

Row modification error!

  • December 30, 2009 at 12:36 am

    #207946

    Hi to all,

    I'm trying to modify the value of the first cell in the first row of my table.The actual value is 'facebook' but while importing from the text file to the sql db some error must've occured and it was imported as 'acebook' So I'm trying to modify the value by editing but the operation throws up the following error:

    can anyone throw some light on this???

    Thank you.

  • December 30, 2009 at 2:10 am

    #1097355

    Rather than using the table viewer (which can be a little glitchy), use the T-SQL commands.

    UPDATE <TableName>

    SET <Column name> = 'facebook'

    WHERE <Column Name> = 'acebook'

    This will update all occurrences of 'acebook' with 'facebook'. If you don't want to update all occurrences, add another filter to the where clause, on the primary key column.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 30, 2009 at 2:28 am

    #1097357

    Also check why the data is getting truncated. Are you using any string functions while importing data.

    "Keep Trying"

  • December 30, 2009 at 4:00 am

    #1097375

    >gilamonster

    >chiragns

    Thanks to both of you.:-) I will try it and post the outcome.

    Thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

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