How do I prompt for user input using SQL Server 2000

[jonmckin]

I know how to do it in Oracle using PL/SQL.

ACCEPT <<variable>> PROMPT 'ENTER VARIABLE: '

Is there a similar construct in TSQL?

[MAK]

create stored procedure and pass parameter.

[jonmckin]

I have a SP, I want it to pause and request the parameter from the user. You can do this in Oracle PL/SQL, but evidently you can't in TSQL

[skhanal]

Unfortunately you can't do it in T-SQL.