Views in SQL Server 2019 with SSMS

Question

Views in SQL Server 2019 with SSMS

Mamta Dalal

SSC Enthusiast

Points: 191
More actions
December 27, 2021 at 8:46 pm

#3964197

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

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

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

Joe Bonomo SSC Veteran Points: 242 More actions · Answer 1

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

Mamta Dalal SSC Enthusiast Points: 191 More actions · Answer 2

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

Joe Bonomo SSC Veteran Points: 242 More actions · Answer 3

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

Joe Bonomo

Views in SQL Server 2019 with SSMS

Cookies on SQLServerCentral