Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2008
    Posts
    21

    Unanswered: Giving access to a stored procedure

    Hi,

    I am somewhat new to SQL, and have a question regarding stored procedures.

    We are running a SQL 2000 and SQL 2005, so if that would make a difference, I could create my stored procedure on either on of those machines.

    My question is, I have the stored procedure that requires one piece of input (1 value). And I would like to give access to this stored procedure to someone who does not have access to SQL server.

    So what would be the easiest and best way to deploy this? Can it easily be linked to an asp page?

    Any help or suggestions are ver much appreciated.
    Thanks,
    Michiel

  2. #2
    Join Date
    Sep 2005
    Posts
    161
    Certainly. Pick your platform. Anything with a data access library will do the trick. ASP, C#, VB, Java, MS Access, PHP, Pearl, Ruby on Rails, C++, Delphi, Foxpro .... just to name a few.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Excel, FileMaker, Microfocus Cobol...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    don't forget Malbolge

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Although I've seen some stored procedure code that leads me to think that the writer was fluent in Malbolge, I know that there is no Malbolge interpreter that is compatible with SQL 2000 and I'm not aware of one for SQL 2005 (atlhough this may be possible using the CLR).

    -PatP

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    I am personally in charge of writing Clipper.Net.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  7. #7
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    Quote Originally Posted by Pat Phelan
    Although I've seen some stored procedure code that leads me to think that the writer was fluent in Malbolge, I know that there is no Malbolge interpreter that is compatible with SQL 2000 and I'm not aware of one for SQL 2005 (atlhough this may be possible using the CLR).

    -PatP
    don't let that stop you. just use xp_cmdshell to call the Malbolge interpreter and you are all set.

    EDIT: anyone fluent in Malbolge deserves a medal. I'd go so far as to say if you can write Hello World in Malbolge you deserve a medal.
    Last edited by jezemine; 07-10-08 at 12:26.

Posting Permissions

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