- SELECT * FROM
- [Master].[dbo].[SYSPROCESSES] WHERE [DBID]
- IN
- (
- SELECT
- [DBID]
- FROM
- [Master].[dbo].[SYSDATABASES]
- WHERE
- NAME='databaseName'
- )
- --该片段来自于http://www.codesnippet.cn/detail/2101201511589.html
来源: http://www.codesnippet.cn/detail/2101201511589.html