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?

  • Hi. You are asking a huge number of questions without giving us enough details to be helpful.

    Specifically, we would need to know the layouts of the tables.

    Speaking personally, I'm not the biggest fan of using views in the manner you propose. However, I admit this to be a personal preference and not a best practice.

    Please send more details so we can get a feel for what you are trying to do.

    Thanks

    John