Row_Number () function doubt

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » Row_Number () function doubt

Row_Number () function doubt

Rate Topic

Display Mode

Topic Options

Author

Message

snigdhandream

Posted Tuesday, June 19, 2012 2:48 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 12:16 AM
Points: 20, Visits: 80

I have a large table having millions of rows. There is one datetime column which captures the date and time a row is inserted to the table. Now, I want to copy the table's data into another server's table with same structure. Here the client wants me to migrate the data in a page by page manner (say 100 rows at a time). This table does not have any identity or unique key. I am thinking of using the row_number () function on the datetime column. But I have one doubt... say the trasaction fails somewhere in between... say at row number 115... it is written like the process will start again from 101 and not from 1. But is there any guarantee that the row_numbers will be same considering the datetime field can have duplicate values?

Regards,
Snigdha

Post #1317784

GilaMonster

Posted Tuesday, June 19, 2012 3:00 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1317787-391-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1317794

« Prev Topic | Next Topic »

Permissions