1. 【強制】在存儲過程中所有的重命名使用一下規范，在所有的命名上需要使用[]將重命名的部分框起來，將變量按照功能進行劃分，并進行注釋
~~~
SELECT
[ProjectCaseStepPointAID] = ISNULL(PFile.ProjectCaseStepPointAID, -1)
,[MyFileAID] = ISNULL(PFile.FileAID, 0)
,[ProjectStepPointFileAID] = PSPF.AID
,[模板文件名] = F1.Name
,[上傳文件名] = PFile.name
--【顯示】
,[文件名稱] = PSPF.Memo
,[文件模板] = F1.Path
,[我上傳的文件] = PFile.Path
--【控制】
,[CanInsert] = CASE WHEN @UserOK = @UserAID THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END
FROM ProjectStepPointFile AS PSPF
INNER JOIN Files AS F1 ON F1.AID = PSPF.FileAID
LEFT JOIN (
SELECT PCSPF.ProjectCaseStepPointAID
,PCSPF.ProjectStepPointFileAID
,PCSPF.FileAID
,F2.Path
,F2.Name
FROM ProjectCaseStepPointFile AS PCSPF
INNER JOIN Files AS F2 ON F2.AID = PCSPF.FileAID
WHERE PCSPF.ProjectCaseStepPointAID = @ProjectCaseStepPointAID
) AS PFile ON PFile.ProjectStepPointFileAID = PSPF.AID
WHERE PSPF.ProjectStepPointAID = (
SELECT t1.ProjectStepPointAID
FROM ProjectCaseStepPoint AS t1
WHERE t1.AID = @ProjectCaseStepPointAID
)
~~~
2. 【強制】注釋不能寫英文，不能寫語法注釋，只能寫業務或者邏輯注釋，模塊前的第一行必須寫這個模塊的注釋，不能使用SELECT *，常量必須定義在最頂部
3. 【強制】在存儲過程中關鍵詞的大小寫規范上，只能使用同一種風格，要不全部大寫，要不全部小寫，嚴禁混用
~~~
正確：SELECT * FROM Users AS U WHERE U.Name LIKE '%云南易用軟件%'
錯誤：SELECT * FROM Users as u WHERE u.sex = 1
~~~
