Post reply

View with parameters

  • October 7, 2002 at 4:43 am

    #79326

    Is it possible to cretae a view with parameters? If so, how.

    Thanks.

  • October 7, 2002 at 4:52 am

    #437936

    No you cannot, only in SPs and sets of code. Views can be used in SPs with parameters but views can only be whole query statments.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • October 7, 2002 at 7:05 am

    #437941

    Thanks. My problem is as follow:

    I have a query in Access which I am moving to SQL server as part of upsizing. The query is paramerized and its resultset is queried by other queries. How best can I recreate the same situation in SQL Server.

    This is why I am thinking of creating the query as a view.

    Thanks for your help.

  • October 8, 2002 at 7:13 am

    #438043

    Hi, i am afraid that you don't have something like that is sql server. You have to create some stored procedures.

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

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