MSSQL脚本编码规范福州星网视易信息系统有限公司更新记录:版本作者日期内容1.0黄晨东2010.09.09SQL脚本编写规范2.0蔡炆炆2010.10.15基于1.0版本进行补充和整理目录Transact-SQL编程规范.....................................................................................................................1一、概述..................................................................................................................................11.基本原则......................................................................................................................12.基本规范......................................................................................................................1二、对象命名..........................................................................................................................11.数据库..............................................................................................................................12.数据库文件......................................................................................................................13.数据表..............................................................................................................................24.数据视图..........................................................................................................................25.数据列..............................................................................................................................26.存储过程..........................................................................................................................27.函数..................................................................................................................................38.用户定义数据类型..........................................................................................................39.主键、索引......................................................................................................................3三、参数命名..........................................................................................................................31.数据列参数..................................................................................................................32.非数据列参数..................................................................................................................43.常用字段命名..................................................................................................................4四、SQL编写...........................................................................................................................41.大小写..............................................................................................................................42.存储格式..........................................................................................................................43.类型选择..........................................................................................................................44.默认值..............................................................................................................................55.字段长度..................................................................................................................