How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
1
Answer
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
In SQL Server following query will be used to create new Table in database;
create Table studentTable(
ID int NOT NULL,
Student_Name varchar(50),
D_O_B datetime
)