It's easy to create tables in sql server.
There are 2 ways to accomplish this task.
-
Right click Tables, in the menu, select Table.
Design your table on the right side.
-
Insert data by command lines. This will be introduced later.
Or you can use import feature to import excel into database.
Right click your database, click Import Data…
In this step click excel, browse the location, then next, here is a Test File for you, names and student numbers all
fake.
Next step, select SQL server Native Client 11.0 in the drop down.
Then select which work sheet you want to import, here you can edit the file name.
Run immediately
Then done!
You can check this at any time here.