It is best to avoid the abbreviated keywords and use the full length ones whereĭo not use database server specific keywords where an ANSI SQL keyword alreadyĮxists performing the same function. _addr-an address for the record could be physical or intangible such asĪlways use uppercase for the reserved keywords._size-the size of something such as a file size or clothing._date-denotes a column that contains the date of something._seq-contains a contiguous sequence of values._name-signifies a name such as first_name._num-denotes the field contains any kind of number._total-the total or sum of a collection of values._status-flag value or some other status of any type such as._id-a unique identifier such as a column that is a primary key.Use the correct suffix where appropriate. The following suffixes have a universal meaning ensuring the columns can be readĪnd understood easily from SQL code. Do not prefix with sp_ or any other such descriptive prefix or Hungarian. monitor_tally ) AS monitor_total FROM staff AS s Stored procedures
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |