Creating paramaterised views

  • is it possible to create views in mssql2000 which accepts param

     

  • NO,

    U can use the Stored procedure for this purpose.

    Basically, I coudn't get where u want to use the views with params, and cann't u use the SPs in that situation ???

     

    Regards

     

     

     

     

     

    Prashant Thakwanithakwani_prashant@yahoo.co.in

  • A table-based UDF is often given the tag "parameterised view".  Check them out in BOL.


    Cheers,
    - Mark

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

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