mssql获取excel进程数量的sql
摘要：
if object_id('tempdb..excel') is not null drop table tempdb..excelcreate table tempdb..excel(outstr varchar(500))insert into tempdb..excelexec master..xp_cmdshell 'TASKLIST /FI "Imagename eq excel.exe"'select case when count(*)=5 then '目前'+cast(count(*)-4 as varchar(20))+'个excel进程' else '无进程' endfr 阅读全文
posted @ 2010-12-31 20:00 gds通用软件开发系统 阅读(246) 评论(1) 推荐(0) 编辑