Skip to content

Instantly share code, notes, and snippets.

@arijusg
Created May 21, 2015 07:47
Show Gist options
  • Save arijusg/0606f935b19379a88637 to your computer and use it in GitHub Desktop.
Save arijusg/0606f935b19379a88637 to your computer and use it in GitHub Desktop.
Running SQL Queries
CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255),
Login VARCHAR(255),HostName VARCHAR(255),
BlkBy VARCHAR(255),DBName VARCHAR(255),
Command VARCHAR(255),CPUTime INT,
DiskIO INT,LastBatch VARCHAR(255),
ProgramName VARCHAR(255),SPID2 INT,
REQUESTID INT)
INSERT INTO #sp_who2 EXEC sp_who2
SELECT *
FROM #sp_who2
-- Add any filtering of the results here :
WHERE --DBName <> 'master'
DBName = 'arijusg-3433Test'
-- Add any sorting of the results here :
ORDER BY DBName ASC
DROP TABLE #sp_who2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment