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.
In both cases, you use the SQL statement INSERT INTO to accomplish the task. INSERT INTO statements are commonly referred to as append queries. To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. To define the value list, use the VALUES clause.