Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    4

    Unanswered: How to use proc's records

    example:

    select * from sp_who

    but it cannot use in QA

  2. #2
    Join Date
    Dec 2003
    Posts
    17
    Try:

    EXECUTE sp_who

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  4. #4
    Join Date
    Jan 2004
    Posts
    4
    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!!!

  5. #5
    Join Date
    Jan 2004
    Posts
    4
    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
    Last edited by wollaston; 01-19-04 at 07:28.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •