i have a problem. i have a table that has one column that should accept one of a set of defined values. i know in MySQL i use the following command to create the table:
CREATE TABLE tblstudents ( studentID int( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT, lastName VARCHAR( 20 ) NOT NULL, initial CHAR( 1 ), firstName VARCHAR( 20 ) NOT NULL, gender ENUM( 'Male', 'Female' ) NOT NULL, PRIMARY KEY studentID ( studentID ) )
what command do i use in SQL Server?