SQL

Sql code posted
created at 24 Dec 17:59

Edit | Back 
1
2
3
4
5
6
7
 
SELECT COUNT(*), 
CAST(hostname AS VARCHAR(20)) AS hostname, 
CAST(program_name AS VARCHAR(30)) AS program_name,
CAST(loginame AS VARCHAR(30)) AS loginame
FROM master..SYSPROCESSES
GROUP BY hostname, program_name, loginame
ORDER BY 1
239 Bytes in 2 ms with coderay