Post reply

SQL Query For Insert

  • August 31, 2010 at 12:19 am

    #223280

    Hi,

    Pls can anyone tell , How to insert other language text using single SQL Query

  • August 31, 2010 at 12:45 am

    #1214053

    Try this:

    CREATE TABLE TempTable ( Col1 NVARCHAR(MAX))

    INSERT INTO TempTable ( Col1)

    SELECT CAST ( <other language column> AS NVARCHAR)

    FROM <Your Table Name>

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

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