基于Microsoft SQL Server存储过程的院内医疗报表统计分析  

The statistical analysis of using Microsoft SQL Server stored procedure to making hospital business statements and reports

作　　者：许泽杰 丁赞 Xu Zejie1 , Ding Zang2.(1 Department of Statistic, GuangDong Second Traditional Chinese Medicine Hospital, Guangzhou 510095, China; 2 Shenzhen Baoan District Central Hospita)

机构地区：[1]广东省第二中医院统计室,广州1510095 [2]深圳市宝安区中心医院

出　　处：《中国医院统计》2017年第6期401-404,共4页Chinese Journal of Hospital Statistics

摘　　要：目的为快速、准确的统计及分析医院医疗业务运行情况提供方法 ,更好的为医院管理提供客观决策依据。方法针对不同的统计报表编写不同的SQL存储过程。结果可以按自定义字段及数据格式查询并导出统计报表。结论编写自定义SQL存储过程可以有效提高统计报表的准确性及统计分析的及时性,更好地为医院管理者提供正确客观的统计参考资料。Objective Propose the methods of statistics to analysis hospital business quickly and exactly, provide the evidence for decision-making of hospital management. Methods For making difference statistical reports and write difference SQL stored procedure statements. Results Query and export statistical reports according to custom fields and data formats. Conclusion Writing custom stored procedure statements can help to improve timeliness and accuracy for making statistical anal- ysis.

关 键 词：SQL 存储过程 统计分析 自定义格式 医改 

分 类 号：R195.4[医药卫生—卫生统计学]