sql操作

批量删除mysql 进程：

select concat('KILL ',id,';') from information_schema.processlist where user='local';



使用dos命令进行sqlserver 数据库附加：

osql -U sa -P sa
go

CREATE DATABASE NBCZ ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NBCZ.mdf') FOR ATTACH

go