qq_44486439的博客

VSCode插件 SQL Server 连接 Microsoft Server SQLSQL Server (mssql)微软公司开发的SQL Server连接VSCode插件安装插件Ctrl+Shift+X输入SQL Server (mssql)，点击install连接MSSQL安装好插件后，在左边的导航栏Activity Bar中选中SQL Server，或快捷键Ctrl+Alt+D添加连接点击Connections右边的加号输入主机名，本机为(local)输入数

pymssql连接mssql环境Win10Python 3.7.4conda 4.7.12pymssql==2.1.4pip安装pip install pymssql在数据库中建表并插入数据的SQL语句create table animal( id int not null, name char(20))insert into animal (id, name) values(0, 'dog')insert into animal (id, name) value