Retriving nvarchar value from varchar column

• Soundari

  SSC Eights!

  Points: 847

  More actions

  July 16, 2009 at 5:05 am

  #155971

  Hi

  By mistake nvarchar value i stored in varchar column, which stored as junk in the database. Is there any way to retrieve the data?

  In the nvarchar column i was having unicode string.

  Any Help please

  Soundari

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  July 16, 2009 at 5:52 am

  #1025545

  No, there really isn't. Once the transaction is committed, it's done.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning