Lets suppose You are executing the given query in SQL Server.
CREATE TABLE TEST
(ID Primary Key,
Name NOT NULL,
Gender NOT NULL,
ContactNo NOT NULL,
Status )
Error Message :
But getting the below errors.
Msg 173, Level 15, State 1, Line 3
The definition for column 'ID' must include a data type.
Causes :
In above SQL statement, Data types are not assigned to columns so above error message is occurred.
Solution of the Error :
Assign the data type to all columns when you are creating table in SQL Server. You can follow the listed data types for columns as per requirement.
Here is the correct way to create table statement.
CREATE TABLE TEST
(ID int Primary Key,
Name Varchar(50) NOT NULL,
Gender Char(1) NOT NULL,
ContactNo Numeric(18,0) NOT NULL,
Status Char(1))
Output :
ID NAME Gender ContactNo Status
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.