Originally posted by rnealejr
Stored procedures require you to "execute" using either of the following formats:
in query analyzer if you are only executing a stored procedure this is not necessary - you can just use sp_who.
If you have not installed sql server books online, you can download it from ms.
I am a chinese.I am not good at english.
I want use only a column from sp_who .
because I create some procedures,but some query only need some part of the procedures.
select spid,ecid,status from sp_who
because I only need the three columns
If you know a little chinese please you refor this:
ÎÒ(I)ÏëÀû(want)ÓÃ(use)´æ´¢¹ý³Ì(procedure)·µ»Ø(retu rn)µÄ½á¹û(records)¡£±ÈÈçÎÒ(I)ÒÑ¾_(already)ÓÐ(have) Á½¸ö(tow)´æ´¢¹ý³Ì(procedures)¿ÉÒÔ·µ»ØÊý¾Ý(records) ¡£µ«ÊÇ(but)ÎÒ(I)ÏÖÔÚ(now)Ïë(want)Í¨¹ý(use)select½« Á½¸ö½á¹û(records)Í¨¹ýjoinÁªºÏÆðÀ´¡£