如何有条件的提取存储过程返回的记录集?
例如sp_who可以查看当前访问数据库的所有进程
如何根据 @@SPID 来返回当前进程访问的那条记录?
--------------------------------
例题如下:
exec sp_who
1 0 background sa 0 NULL LAZY WRITER
2 0 sleeping sa 0 NULL LOG WRITER
3 0 background sa 0 master SIGNAL HANDLER
4 0 background sa 0 NULL LOCK MONITOR
5 0 background sa 0 master TASK MANAGER
6 0 background sa 0 master TASK MANAGER
7 0 sleeping sa 0 NULL CHECKPOINT SLEEP
8 0 background sa 0 master TASK MANAGER
9 0 background sa 0 master TASK MANAGER
10 0 background sa 0 master TASK MANAGER
11 0 background sa 0 master TASK MANAGER
12 0 background sa 0 master TASK MANAGER
13 0 background sa 0 master TASK MANAGER
51 0 runnable BILLGATES\EPox8KHA-DDR BILLGATES 0 master SELECT
52 0 sleeping BILLGATES\EPox8KHA-DDR BILLGATES 0 master AWAITING COMMAND
select @@spid
51
如何得到如下记录
51 0 runnable BILLGATES\EPox8KHA-DDR BILLGATES 0 master SELECT