Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

How do we bcp using row_number()

Since I have a table which has no unique key / PK, what is the best way for me to do bcp to just grab record which not being collected, I have  column in the table call date_time which has getdate() values, so usually our data has around 50 millions to copy for each month, so I'm thinking to run this bcp daily can I us row_number() here ?
0
motioneye
Asked:
motioneye
1 Solution
 
Amgad_Consulting_CoCommented:
Hi,

it will not be a good idea, can't you just add am extra column as a PK (bigint, autonumber) just to use to identify a row nothing more.
0
 
motioneyeAuthor Commented:
I have find out another solution which using date and time function in sql server
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now