How many total batting partners were most successful in the 2006 season?
CREATE TABLE table_1670921_2 (batting_partners VARCHAR, season VARCHAR)
SELECT COUNT(batting_partners) FROM table_1670921_2 WHERE season = "2006"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1670921_2 (batting_partners VARCHAR, season VARCHAR) Question: How many total batting partners were most successful in the 2006 season? [/INST] SELECT COUNT(batting_partners) FROM table_1670921_2 WHERE season = "2006" </s>