Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: MS SQL 2000 using Mobilink question

    Hello,

    I am trying to get my PDA program to work on MS SQL 2000, which I originally designed using Sybase ASA 8.

    From what I have read, MS SQL 2000 does not support variables as ASA does, but functions may be able to do what I need them to do.

    What I am trying to figure out is what I need to do to get it set up so that in MS SQL, there is something that will work like a session-wide variable that holds the user_id, and how to call it from scripts.

    Any ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Transact SQL definitely supports variables, almost exactly like ASA server does. What you want is available from a function called suser_sname() so I'd just use that.

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Ok, thanks.

    I will give that a go, and tell you how it works out.

Posting Permissions

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