Question: I keep getting this error after trying to execute this Query. An error occurred when executing the SQL command: CREATE TABLE EMPLOYEEATTRITION ( ID_column INT
I keep getting this error after trying to execute this Query.
An error occurred when executing the SQL command: CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40),... Io exception: Operation timed out (Read failed) [DB Errorcode=17002] 1 statement failed. Execution time: 2m 32s
The query that I`m having trouble with is..
CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40), DAILYRATE INT, DEPARTMENT VARCHAR(20), DISTANCEFROMHOME VARCHAR(10), EDUCATION INT, EDUCATIONFIELD VARCHAR(20), EMPLOYEECOUNT INT, EMPLOYEENUMBER INT, ENVIRONMENTSATISFACTION INT, GENDER VARCHAR(10), HOURLYRATE INT, JOBINVOLVEMENT INT, JOBLEVEL INT, JOBROLE VARCHAR(30), JOBSATISFACTION INT, MARITALSTATUS VARCHAR(10), MONTHLYINCOME INT, MONTHLYRATE INT, NUMCOMPANIESWORKED INT, OVER18 CHAR(1), OVERTIME VARCHAR(5), PERCENTSALARYHIKE VARCHAR(5), PERFORMANCERATING INT, RELATIONSHIPSATISFACTION INT, STANDARDHOURS INT, STOCKOPTIONLEVEL INT, TOTALWORKINGYEARS INT, TRAININGTIMESLASTYEAR INT, WORKLIFEBALANCE INT, YEARSATCOMPANY INT, YEARSINCURRENTROLE INT, YEARSSINCELASTPROMOTION INT, YEARSWITHCURRMANAGER INT );
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
