What is the party affiliation for Senator David Goodman? 
CREATE TABLE table_26129220_2 (party VARCHAR, senator VARCHAR)
SELECT party FROM table_26129220_2 WHERE senator = "David Goodman"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_26129220_2 (party VARCHAR, senator VARCHAR) Question: What is the party affiliation for Senator David Goodman?  [/INST] SELECT party FROM table_26129220_2 WHERE senator = "David Goodman" </s>