How to Create Tables
来源:互联网 发布:数字规律软件 编辑:程序博客网 时间:2024/05/22 02:09
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.
<<MS course.xlsx>>
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.
0 0
- How to Create Tables
- Freeform SQL (FFSQL) - Tip - How to create TEMP(Temporary) tables
- How to create simple and advanced pivot tables in C# and ASP.NET
- How to create singleton
- How to create alarm
- How to create WCF
- java How to Use Tables
- Siebel HOW TO: How to create Products?
- How to Create a Customer
- How to create Firefox extensions
- How to create new geodatabases
- how to create cifs.ko
- How to create EPS files...
- How to create PFX file
- how to create a Makefile
- [AngularJS] How to create Directives?
- How to create recovery image
- how to create proxies pool
- 【PHP高级】Smarty模板(一)
- Java 性能优化的五大技巧
- Java 二维码 Base64转Qrcode
- LibEvent中文帮助文档-第8章【处理事件】
- Android 微信支付详解与Demo
- How to Create Tables
- Java调用MySQL的存储过程
- PHP的小技巧
- 《连载 | 物联网框架ServerSuperIO教程》- 14.配制工具介绍,以及设备驱动、视图驱动、服务实例的挂载
- Tips: Create An Empty Table Has Same Columns with Existed Table
- 【OI做题记录】【BZOJ】【Usaco2008 Mar】土地购买
- 【剑指offer】按层和按之字打印二叉树
- 开源物联网框架ServerSuperIO 3.0正式发布(C#),跨平台:Win&Win10 Iot&Ubuntu&Ubuntu Mate,一套设备驱动跨平台挂载,附:开发套件和教程。
- 计算机导论1