Post reply

Views in SQL Server 2019 with SSMS

  • December 27, 2021 at 2:22 pm

    #3967508

    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

  • December 27, 2021 at 8:46 pm

    #3964197

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

  • December 27, 2021 at 9:05 pm

    #3967607

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

  • December 27, 2021 at 11:06 pm

    #3967623

    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