Post reply

ROWIDTOCHAR

  • June 23, 2008 at 8:37 am

    #192852

    hi,

    i am converting the database from Oracle to SQL server 2005. In Oracle they used rowidtochar(rowid) and inserting this value in to the database. the value like 'AAAMmxAAEAAAAjcAAx'. Now i need to insert the same format data in to the sql server database. how to get this value. What is the related in sql server for the rowidtochar(rowid) function.

    thanks in advance.

  • June 23, 2008 at 9:01 am

    #832767

    We don't really have an equivalent to that function. If the values already exist in the data you're importing then assign varchar on the target. If not, then you'll have to build the value by hand for each row.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • June 23, 2008 at 9:02 am

    #832769

    SQL doesn't have an equivalent to the Oracle RowID.

    What are you trying to achieve?

    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

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

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