在sqlserver数据库添加数据的步骤如下:
以一个Student表为例,数据中有StudentNo、StudentName、GradeId、Phone这几列。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fd16f4463bdb88d43f869427b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2. 在表中右击然后选择里面的编辑前200行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5243fbf2b211931333601ffe68380cd791238d59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3. 在弹出窗口中,就是我们要添加数据的数据列,手动输入数据,如张三、1、手机号等等。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f9bb47b527282dd42a2834a428?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4. 添加完毕几个内容之后,在表中右击选择执行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a1ec08fa513d269716cdeb1358fbb2fb4316d866?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5. 执行完毕之后,选择新建查询语句,然后输入查询语句:
select * from Student
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfa031225a0b98f8c5494ee7b06?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6. 输入后选择全部内容,然后选择执行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/00e93901213fb80ee0a182993bd12f2eb9389408?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7. 执行完成后,数据库里就能看到新插入的数据内容了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8014c086e061d9537e7d47676f40ad163d9cadf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)