Post reply

User Input in TSQL

  • February 21, 2005 at 9:17 am

    #86912

    There is a procedure called NewProfile with three parameter ,the username,password and a profile (which will be got from the database).like & in oracle?

    Any help on this will be greatly appreciated

     

    TIA

    Michael

  • February 21, 2005 at 9:43 am

    #543350

    What exactly are you trying to do?

  • February 22, 2005 at 6:00 pm

    #543589

    Are you looking for the equivalent of Oracle sqlplus commands define, prompt and accept?  These are only available in sqlplus - not in pl/sql.

    T-sql is a poor cousing of  pl/sql - hence no prompts for user input during a script run. And no variables that can be passed between batches in the same run.

    Cheers,

    Win

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply