Creating paramaterised views

• smart1967

  Newbie

  Points: 7

  More actions

  March 4, 2004 at 10:49 pm

  #163153

  is it possible to create views in mssql2000 which accepts param

   

• *Prashant Thakwani

  SSCommitted

  Points: 1827

  More actions

  March 4, 2004 at 10:52 pm

  #497454

  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

• mccork

  SSC-Insane

  Points: 22288

  More actions

  March 9, 2004 at 2:28 am

  #497934

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

  
  Cheers,
  - Mark