Home Forums SQL Server 2008 SQL Server Newbies Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'Noida' to data type int. RE: Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'Noida' to data type int.

  • March 17, 2013 at 4:09 am

    #1597869

    Thanks A Lot!!!!:-):-)

    That worked perfectly. Yes were are only two records in the table as of now.

    Where i wanted to swap the city details to some desired.

    Well do u meant to use 'Where' clause for tuning/Performance? Faster transactions?