Monday, March 19, 2012

How to use procs records

example:
select * from sp_who
but it cannot use in QATry:

EXECUTE sp_who|||Stored procedures require you to "execute" using either of the following formats:

exec sp_who
execute sp_who

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.|||Originally posted by rnealejr
Stored procedures require you to "execute" using either of the following formats:

exec sp_who
execute sp_who

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.
example:
select spid,ecid,status from sp_who
because I only need the three columns

thanks for answer my question!!!|||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

No comments:

Post a Comment