Views in SQL Server 2019 with SSMS

  • Did you consider putting in a word of caution using the view designer? The view designer can lead to mangled SQL code. Example, having a right join, left join, right join, left join, where all the tables are either 1:N or N:1. The code becomes unreadable and unmaintainable. We effectively ban using the designer.

    Joe Bonomo

  • Comments posted to this topic are about the item Views in SQL Server 2019 with SSMS

  • Thank you for reading the article and sharing your inputs, Joseph. I appreciate them. An updated version of the article already mentions about this.

  • Thanks! Apologies if I missed that on the first read but I see that there now.

    Joe Bonomo

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply