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.
The following code shows how to add a new record to a DataTable and then call the TableAdapter.Update method to save the new row to the database. (This example uses the Northwind database Region table.) C#. VB. Copy. // Create a new row.