Hello All,
What should I consider when trying to choose between a Federated table and a
View when I have one table's data that I'd like to be available in other
databases on the same host.
My view definition would be something like:
CREATE
[some options]
VIEW
[this_db].[this_view] AS
Hello all,
I have an 'items' table with 2 'types' of items -- 'foo' & 'bar'
Say that items of type 'bar' may be further classified as 'subtypes' 'baz',
'quux', etc.
Now I build an online store so that visitors may buy items.
Contstraints
1.) I would like to, as much as possible, use the same c