created a prompt in a view?

[aspnetuser]

Is it possible to create a prompt in a view?

I don't have access to SP or functions at present and need a quick fix.

i need to prompt or a id field.

enter_id

user will enter 1

return view results...

possible?

 

[Suziii]

i think it's not possible to prompt in a view, but it's possible in a stored procedure.


Create Procedure nameOfStoredProcedure

@enter_id float

AS

SELECT * FROM table WHERE id = @enter_id;