Hello, I've got a bit of an unusual request, I want to create some duplicate rows in a SQL Server table. We have a WorkOrders table that has our customer orders in it. Every order has a WOID ...

The new column will create an incrementing integer which is basically a pointer to the row number of the results. To do this in MS SQL Server, add the following to the beginning of your column ...

They have their own server with a SQL Server database holding the data ... No checks are made to ensure that it doesn't attempt to insert duplicate records. Furthermore, upon using bcp to copy ...