SQL Server equivalent to MySQL enum data type?

It doesn’t. There’s a vague equivalent:

mycol VARCHAR(10) NOT NULL CHECK (mycol IN('Useful', 'Useless', 'Unknown'))