When the Vancouver Canucks were visiting, what was the record when the score was 4-2?
CREATE TABLE table_name_6 (record VARCHAR, score VARCHAR, visitor VARCHAR)
SELECT record FROM table_name_6 WHERE score = "4-2" AND visitor = "vancouver canucks"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (record VARCHAR, score VARCHAR, visitor VARCHAR) Question: When the Vancouver Canucks were visiting, what was the record when the score was 4-2? [/INST] SELECT record FROM table_name_6 WHERE score = "4-2" AND visitor = "vancouver canucks" </s>