1 Surly: Surly may refer to: One of the Seven Duffs in The Simpsons cartoon Surly Bikes, Bloomington, MN, USA Surly Brewing Company, Brooklyn Center, MN, USA. Surly Brewing Company: The Surly Brewing Company is a Brooklyn Center, Minnesota-based craft brewery, noted for well-reviewed beers and primarily canning, rather than bottling. 2  Surly Bob: For the former sports bar in Yellowknife see Surly Bob's Surly Bob is a 19th-century English children's novel by Luisa C. Silke.
It may not be easy in SQL Server 2000. SQL Server 2005 provides ROW_NUMBER() function which is pretty useful for this kind of requirement. I guess, with SQL server 2000 you dont have many options. 1. Create a memory table which has an identity column.Insert values to the memory table and then select it from there.QL Server 2005 provides ROW_NUMBER() function which is pretty useful for this kind of requirement. I guess, with SQL server 2000 you dont have many options. 1. Create a memory table which has an identity column.
You should add the auto increment column to the DataTable before you pouplate it with the other data: Then you don't have to add the auto incremented values yourself in some kind of a loop (using for example LINQ or foreach). have a data table (of DataTable type) pre-populated with many rows (50000+), parsed from a log file. Now I need to add a column that will be holding index number for each records; eg. 1, 2, 3...... I have tried to add the auto-incremented column dynamically, with seed = 0 and increment = 1, but it is not working.