Thanks, that helps!
The one question I had though was about Views and indexes. My app opens tables and sets indexes. Can I just replace all my references to tables (USE MyTable) with Views (USE MyView) ?
If so, how do I allow my app to set indexes on Views ? (SET ORDER TO TAG..)
Or is this the totally wrong way to do it ?
I probably should have originally designed the app with views, but at that point SQL Server was something I had no designs on tackling.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only