locked
What are "ClassifiedsView_Ads" and "PhotosView" used for ?? RRS feed

  • Question

  • User-1980716583 posted

    This two items are stored in the DB "Views" folder,  i have a bit of knowledge about relational database, tables, keys/foreignKeys, etc.

    But i don't understand for what this two views are used for.

     Thanks in advance for any help you might give me.

    Tuesday, November 11, 2008 7:16 PM

All replies

  • User-1980716583 posted

    I think i solved my own problem,

     The  "ClassifiedsView_Ads" view seems to be used on the stored procedures:

    (ClassifiedsView_Ads ; GetAllAdsByQuery; GetAdsByStatus , GetAdsByRandomOrder)

     

     So "PhotosView" must be used also on a storedProcedure wich i still didnt saw.

    Wednesday, November 12, 2008 3:26 PM
  • User-1980716583 posted

     

    Later on, while i was reading about t-sql, i foud we can build "views", which are some kind of subsets of tables.

    So i understand now why these wo views where used.

    Sunday, March 22, 2009 6:32 PM