what is the total number of census designated places with a population of 10581?
CREATE TABLE table_22916979_2 (census_designated_place VARCHAR, population__2000_census_ VARCHAR)
SELECT COUNT(census_designated_place) FROM table_22916979_2 WHERE population__2000_census_ = 10581
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22916979_2 (census_designated_place VARCHAR, population__2000_census_ VARCHAR) Question: what is the total number of census designated places with a population of 10581? [/INST] SELECT COUNT(census_designated_place) FROM table_22916979_2 WHERE population__2000_census_ = 10581 </s>