sql.server.設(shè)計(jì)、命名、編碼規(guī)范

1、1SQLServer設(shè)計(jì)、命名、編碼規(guī)范SQLServerDatabaseDesignCodeDevelopmentStards1.更改..................................................................................................42.簡(jiǎn)介.................................................

2、.................................................43.開發(fā)環(huán)境.............................................................................................53.1數(shù)據(jù)庫(kù)模型..............................................................

3、....................53.2Diagrams..................................................................................53.3版本控制.....................................................................................53.4源碼目錄結(jié)構(gòu)...

4、...........................................................................54.物理數(shù)據(jù)庫(kù)模型&字典.............................................................................64.1物理數(shù)據(jù)模型.............................................

5、.................................64.2IDEF1X方法..............................................................................74.3物理數(shù)據(jù)庫(kù)數(shù)據(jù)字典......................................................................74.4性能設(shè)計(jì)......

6、..............................................................................75命名協(xié)定...........................................................................................85.1數(shù)據(jù)庫(kù)命名原則及版本控制.............................

7、.................................85.1.1數(shù)據(jù)庫(kù)命名原則....................................................................85.1.2數(shù)據(jù)庫(kù)版本控制...................................................................85.2Server命名實(shí)例的命名.........

8、.........................................................85.3數(shù)據(jù)庫(kù)命名.................................................................................95.4數(shù)據(jù)庫(kù)對(duì)象—表，視圖，列名，約束，規(guī)則，默認(rèn)值..............................115.5縮寫規(guī)范.......

9、...........................................................................125.6列名........................................................................................125.7存儲(chǔ)過(guò)程命名.......................................

10、......................................145.8游標(biāo)命名..................................................................................145.9觸發(fā)器命名...............................................................................15

11、5.10索引命名................................................................................155.11主鍵和外鍵命名........................................................................155.12Check約束命名................................

12、........................................165.13源文件命名..............................................................................165.14Job的命名..............................................................................1

13、65.15用戶自定義函數(shù)命名...................................................................1731.更改更改ChangeNameDate命名原則：表意性原則（增加）DavidDongJan05數(shù)據(jù)庫(kù)命名DavidDongJan05表命名DavidDongJan05ServerInstance命名DavidDongJan05JOB復(fù)制命名DavidDongJan052

14、.簡(jiǎn)介簡(jiǎn)介數(shù)據(jù)庫(kù)設(shè)計(jì)是指對(duì)于一個(gè)給定的應(yīng)用環(huán)境，構(gòu)造最優(yōu)的數(shù)據(jù)庫(kù)模式，建立數(shù)據(jù)庫(kù)及其應(yīng)用系統(tǒng)，有效存儲(chǔ)數(shù)據(jù)，滿足用戶信息要求和處理要求數(shù)據(jù)庫(kù)設(shè)計(jì)和開發(fā)標(biāo)準(zhǔn)是使NeweggSupptCenter的數(shù)據(jù)庫(kù)系統(tǒng)的設(shè)計(jì)和開發(fā)正式化的標(biāo)準(zhǔn)。通過(guò)此標(biāo)準(zhǔn)，來(lái)規(guī)范數(shù)據(jù)庫(kù)設(shè)計(jì)。通過(guò)一致的系統(tǒng)解決方案，能給我們的系統(tǒng)帶來(lái)以下優(yōu)點(diǎn)：?開發(fā)出高可管理性的高質(zhì)量系統(tǒng)?能夠快速的進(jìn)行開發(fā)?減少維護(hù)代碼的時(shí)間??非常容易的把代碼從一個(gè)項(xiàng)目拷貝至另一個(gè)項(xiàng)目??節(jié)省把游