Home Forums SQL Server 2012 SQL Server 2012 - T-SQL If I understand Views VS Functions correctly...I should use views to enapsulated commonly used where clauses? RE: If I understand Views VS Functions correctly...I should use views to enapsulated commonly used where clauses?

  • We have a database that we store all of our 'reference' type tables like this. We just try to give it a descriptive name and let everyone know about it. (name of table/database, what values it contains and how to join to it) I think if you can get everyone on board with either one database to store this type of data or one common table prefix for these type of tables you should be able to limit any duplication.

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.