Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understanding Views
Message
 
 
À
08/11/2013 10:20:46
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01587551
Message ID:
01587560
Vues:
39
>Hi, Dmitry,
>
>Brandon gave a terrific response on views. His point #3 is perhaps the biggest of all. Big conversions of legacy databases to new databases will often use views in the transition phase, and even beyond that. You'll also find them often in reporting applications.
>
>Generally, what's stored in a view is just the SQL query itself, not the data.
>
>Just wanted to add two additional things
>
>First, in SQL Server (don't know about Oracle), you can't pass parameters to views. There are workarounds (sometimes using table-valued functions), though they tend to be a bit involved.
>
>Second, there's one instance where a view actually "stores" data - a materialized view. It almost sounds like a contradiction in terms. It's not terribly common, but some people use them for fast retrieval of aggregated data. There are several requirements for a materialized view, so you won't seem them often.

Hi Kevin,
Yes, Brandon's message gave me a good understanding of what I didn't know about views. I appreciate your input too. In my case I was not looking for using views for a legacy database. I have a rather complicated case where some data is periodically "sent" to XML files (for user to get and process). I had an idea of replacing the XML files with views. But now that I understand - conceptually - how views work, this approach is not for me.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform