Coding Conventions
I'll cover common coding and design patterns in more detail in Chapter 3, but discussing a few basic coding conventions is certainly worthwhile here. You'll see these conventions applied throughout this book, so it makes sense to talk about a few of them in advance.
As I've said, I'm uncomfortable telling you exactly what conventions you should use. I think you should find a system that works for you. Nevertheless, I've structured the following recommendations as a series as dos and don'ts because you may want to adopt some of them as guidelines for your own work. You may not agree with or even use all of these. My advice would be to read through them and adopt the ones that you feel make the most sense.
Script Recommendations ...
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.