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.
All SQL statements should end with a ;. The table and column names must start with a letter and can be followed by letters, numbers, or underscores-not to exceed a total of 30 characters in length. Do not use any SQL reserved keywords as names for tables or column names (such as select, create, insert, etc).