1、打开CMD命令界面。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759ee40b4f2a0bdfb43166c22dff1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、先我们可以运行 osql ?/ ,这样就把所有可以通过CMD命令行操作sqlserver的命令显示出来。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3bf33a87e950352a6fe9b7635c43fbf2b3118bd5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、写语句是请注意大小写。要按照下图中的写法写,不然会不识别。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9358d109b3de9c8220b66be46381800a18d8438e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后我们知道connect 服务器是-S,登陆ID是-U,密码是-P ,运行 osql -S 【数据库服务器】 -U 【登陆用户名】 -P 【登陆密码】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d4628535e5dde7114389d19da8efce1b9d166106?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、出现 1> 表示连接成功,这时候你可以输入sql语句来进行操作了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1a20cf431adcbefcb6fec6da3af2edda3cc9f06?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、请记住在2>时输入GO,执行Sql语句。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4610b912c8fcc3ced7355b589d45d688d53f20e7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后就可以开始使用SQL命令操作SqlServer数据库了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8694a4c27d1ed21b132ebc8ea26eddc450da3ff1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)