Đang chuẩn bị liên kết để tải về tài liệu:
SQL PROGRAMMING STYLE- P47

SQL PROGRAMMING STYLE- P47:Im mot trying to teach you to program in SQL in this book. You might want to read that again. If that is what you wanted, there are better books. This ought to be the second book you buy, not the first. I assume that you already write SQL at some level and want to get better at it. If you want to learn SQL programming tricks, get a copy of my other book, SQL for Smarties (3rd edition, 2005). | To Eve Astrid Andersson Miss American n And April Wilson who rubs me the right way. CONTENTS Introduction xv 1 Names and Data Elements 1 1.1 Names 2 1.1.1 Watch the Length of Names 2 1.1.2 Avoid All Special Characters in Names 3 1.1.3 Avoid Quoted Identifiers 4 1.1.4 Enforce Capitalization Rules to Avoid Case-Sensitivity Problems 6 1.2 Follow the ISO-11179 Standards Naming Conventions 7 1.2.1 ISO-11179 for SQL 8 1.2.2 Levels of Abstraction 9 1.2.3 Avoid Descriptive Prefixes 10 1.2.4 Develop Standardized Postfixes 12 1.2.5 Table and View Names Should Be Industry Standards Collective Class or Plural Nouns 14 1.2.6 Correlation Names Follow the Same Rules as Other Names . . . Almost 15 1.2.7 Relationship Table Names Should Be Common Descriptive Terms 17 1.2.8 Metadata Schema Access Objects Can Have Names That Include Structure Information 18 1.3 Problems in Naming Data Elements 18 1.3.1 Avoid Vague Names 18 1.3.2 Avoid Names That Change from Place to Place 19 1.3.3 Do Not Use Proprietary Exposed Physical Locators 21 2 Fonts Punctuation and Spacing 23 2.1 Typography and Code 23 2.1.1 Use Only Upper- and Lowercase Letters Digits and Underscores for Names 25 2.1.2 Lowercase Scalars Such as Column Names Parameters and Variables .